Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT s.name AS "Symptoom"
- FROM ziekte z
- INNER JOIN koppeling k ON k.ziekte_id = z.id
- INNER JOIN symptomen s ON s.id =k.symptoom_id
- WHERE z.name = "mazelen"
- EXCEPT
- SELECT s.name AS "Symptoom"
- FROM ziekte z
- INNER JOIN koppeling k ON k.ziekte_id = z.id
- INNER JOIN symptomen s ON s.id =k.symptoom_id
- WHERE z.name = "diabetes"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement