Joins
What tables have these columns?
Are all the tables related in some way?
If not, are there other tables that can relate them?
How are they all related?
Link them together by setting their common fields equal in the WHERE clause.
Restrict the WHERE clause to the record(s) of interest.