Guest User

Untitled

a guest
Nov 19th, 2018
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.45 KB | None | 0 0
  1. INSERT INTO prices (price, product_id)
  2. SELECT
  3. product_price, commn_id
  4. FROM products_temp as prod
  5. WHERE NOT EXISTS
  6. (SELECT *
  7. FROM prices od
  8. WHERE prod.commn_id = od.product_id)
  9. OR prod.product_price !=
  10. ( SELECT price
  11. FROM prices as p
  12. WHERE p.product_id = prod.commn_id
  13. order by p.end
  14. desc LIMIT 1 )
  15.  
  16. OR prod.product_price !=
  17. ( SELECT price
  18. FROM prices as p
  19. WHERE p.product_id = prod.commn_id
  20. order by p.end
  21. desc LIMIT 1 )
Add Comment
Please, Sign In to add comment