This week's book giveaway is in the Mac OS forum. We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line! See this thread for details.
Azz, Your query is good first step. It sets up the join structure.
There is a concept called an outer join. The syntax varies by database. You can find the syntax by looking at your documentation or googling your database and "outer join". The concept is the same across databases.