Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT model, price FROM pc WHERE model IN (SELECT model FROM product WHERE TYPE= 'pc' AND maker= 'B')
- UNION
- SELECT model, price FROM laptop WHERE model IN (SELECT model FROM product WHERE TYPE= 'laptop' AND maker= 'B')
- UNION
- SELECT model, price FROM printer WHERE model IN (SELECT model FROM product WHERE TYPE= 'printer' AND maker= 'B')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
