Advertisement
Guest User

Untitled

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