I'm having difficulties writing a SQL query that checks for information on a different table.
I'm sure the query is pretty easy using join (or so I think), but I just can't figure out how to use join (I never fully understood JOIN ).
I wrote a small example for my tables + the expected result. It can be found here. Can someone please explain what I'm missing?
Thanks a lot.