Advertisement
Guest User

Untitled

a guest
Nov 27th, 2014
253
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.30 KB | None | 0 0
  1. SELECT product.model,price FROM product JOIN pc ON product.model=pc.model WHERE maker='B'
  2. UNION
  3. SELECT product.model,price FROM product JOIN Laptop ON product.model=Laptop.model WHERE maker='B'
  4. UNION
  5. SELECT product.model,price FROM product JOIN Printer ON product.model=printer.model WHERE maker='B'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement