Hi,
Use the Joining conditions in the where clause for the all the tables with their primary constraints.