Evra70

a

Dec 8th, 2021
970
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select COUNT(product_id),product_id
  2. from table_check A
  3. WHERE EXISTS (
  4. select 1
  5. from m_product B
  6. where product_code IN (
  7. 'code_dalam_lampiran'
  8. )
  9. AND A.product_id = B.product_id
  10. )
  11. group by product_id
RAW Paste Data