Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT *
- FROM(
- SELECT manfacturer, "pc" as type
- FROM products
- JOIN pc ON pc.model = product.model) as pcs
- JOIN (
- SELECT manf, "lt" as type
- FROM products
- JOIN pc ON lt.model = product.model) as lps ON lps.manf = pc.manf)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement