Advertisement
Guest User

Untitled

a guest
Jan 17th, 2018
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.27 KB | None | 0 0
  1. SELECT winefarm.name, wine.name, grabe.name
  2. FROM winefarm
  3. FULL OUTER JOIN wine
  4. ON winefarm.wf_id = wine.wf_id
  5. FULL OUTER JOIN contains
  6. ON wine.w_id = contains.w_id
  7. FULL OUTER JOIN grape
  8. ON contains.g_id = grape.g_id
  9. GROUP BY grape.g_id
  10. ORDER BY winefarm.name ASC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement