Advertisement
Guest User

Untitled

a guest
Mar 20th, 2019
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.33 KB | None | 0 0
  1. SELECT s.name AS "Symptoom"
  2. FROM ziekte z
  3. INNER JOIN koppeling k ON k.ziekte_id = z.id
  4. INNER JOIN symptomen s ON s.id =k.symptoom_id
  5. WHERE z.name = "mazelen"
  6.  
  7. EXCEPT
  8.  
  9. SELECT s.name AS "Symptoom"
  10. FROM ziekte z
  11. INNER JOIN koppeling k ON k.ziekte_id = z.id
  12. INNER JOIN symptomen s ON s.id =k.symptoom_id
  13. WHERE z.name = "diabetes"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement