CodeFriends
Use EXISTS and NOT EXISTS to test for row presence in subqueries.
Learn the difference between IN and EXISTS, and when to use each.