Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql>
- -- I want order_uuid's which don't have program_option_uuid in (215688, 215689)
- select order_uuid, program_option_uuid from order_detail where order_uuid in (725244, 200000);
- mysql> +------------+---------------------+
- | order_uuid | program_option_uuid |
- +------------+---------------------+
- | 200000 | 2270 |
- | 200000 | 2272 |
- | 200000 | 2276 |
- | 200000 | 2291 |
- | 725244 | 215701 |
- | 725244 | 215688 |
- | 725244 | 215688 |
- +------------+---------------------+
- 7 rows in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement