Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT *
- FROM TABLE_1 t
- WHERE NOT EXISTS
- (SELECT *
- FROM TABLE_2 x
- WHERE t.PRIMARY_KEY_1 = x.PRIMARY_KEY_1
- AND t.PRIMARY_KEY_2 = x.PRIMARY_KEY_2
- AND t.PRIMARY_KEY_3 = x.PRIMARY_KEY_3
- AND ...
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement