Advertisement
Guest User

Untitled

a guest
Apr 23rd, 2018
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.25 KB | None | 0 0
  1. GO
  2. SELECT p.*
  3. FROM price
  4. LEFT JOIN product AS p ON p.id = price.product_id
  5. WHERE price.salessituation_id != 1
  6. EXCEPT
  7. SELECT p.*
  8. FROM price
  9. LEFT JOIN product AS p ON p.id = price.product_id
  10. WHERE price.salessituation_id = 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement