Since a Query of Query only supports INNER JOIN syntax, many developers are left frustrated because the incredibly useful LEFT OUTER JOIN is unavailable. Alistair Davidson has come up with a solution using the support UNION syntax.
For those of you now asking "what is an inner join? What is a left outer join?" I have provided an explanation in pictures and words. (complete with a typo of the word "columns")