just a quick reminder about Sql joins folks- I've been pulling my hair out with them recently:

1. Only one inner join is available to SQL and you write it as "inner join" and it returns only matches, IE it removes lines from the resulting dataset.
Also, no left or right variations here are available.
2. left and right outer joins return either all the left or right rows and null on thing that don't math.