when you create a join the comparison has a table on the left and a table on the right:
INNER JOIN LeftTBL.IdColumn ON RightTBL.IDColumn
Whether to use a Right or left join depends on the table on the right or left, the data in each of those tables and the expected results.
thanks jason, i will have a loot at this. i have tried to understand by reading around before.
i take it the left table is the one you declare first in the query?
also how would you create multiple joins? so say i wanted to join my insurance table to clients and clients with users table so i could filter by userid?