Know the joins
If you don’t know enough to…
Understand the nature and purpose of the joins…
You don’t know enough to write the SQL!