Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT Product.model,
- COALESCE(PC.price, Laptop.price, Printer.price)
- FROM Product, PC
- FULL JOIN Laptop ON 1=2
- FULL JOIN Printer ON 1=2
- WHERE maker = 'B' AND (
- Product.model = PC.model OR
- Product.model = Laptop.model OR
- Product.model = Printer.model)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement