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.