club306: JOIN, IN, EXISTS wonders if there is any difference between these three. I recommend reading this link and this link for some detailed analysis. Net net, they overlap but provided different results in important situations.
In the test are we responsible for all three (ie are you going to ask specifically) or can we use any of the three when ask to join multiple tables?
You need to be able to recognize when they are similar.