Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select . . . -- whatever columns you want
- from customer_items ci
- union all
- select . . . -- corresponding columns
- from master_items mi
- where not exists (select 1
- from customer_items ci2
- where ci2.ciname = mi.name
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement