Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT order_num, 'Invalid Order Nums' "Order Numbers"
- FROM order_table
- where order_num NOT IN
- --(or NOT EXISTS IN)
- (select order_num
- from order)
- ORDER_NUM Order Numbers
- --------- ------------------
- 21615 Invalid Order Nums
Add Comment
Please, Sign In to add comment
