Again this is really helpful. I hope you all won't mind a follow-up question:

What is the difference between...

WHERE [column] IN ([subquery])

and

WHERE EXISTS ([subquery])

?

I've been trying to read on it and trying queries on my test server but can't come up with anything helpful. Would someone mind explaining? I want to be able to support my code 🙂