Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT winefarm.name, wine.name, grabe.name
- FROM winefarm
- FULL OUTER JOIN wine
- ON winefarm.wf_id = wine.wf_id
- FULL OUTER JOIN contains
- ON wine.w_id = contains.w_id
- FULL OUTER JOIN grape
- ON contains.g_id = grape.g_id
- GROUP BY grape.g_id
- ORDER BY winefarm.name ASC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement