Advertisement
Guest User

Untitled

a guest
Oct 30th, 2014
127
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.62 KB | None | 0 0
  1. mysql>
  2. -- I want order_uuid's which don't have program_option_uuid in (215688, 215689)
  3. select order_uuid, program_option_uuid from order_detail where order_uuid in (725244, 200000);
  4. mysql> +------------+---------------------+
  5. | order_uuid | program_option_uuid |
  6. +------------+---------------------+
  7. | 200000 | 2270 |
  8. | 200000 | 2272 |
  9. | 200000 | 2276 |
  10. | 200000 | 2291 |
  11. | 725244 | 215701 |
  12. | 725244 | 215688 |
  13. | 725244 | 215688 |
  14. +------------+---------------------+
  15. 7 rows in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement