use and outer join. Typically 1 table has a list of values that you want to see all the time. This becomes the 'main' table, the rest of the tables can be left outer joined to this table or left outer joined to the appropriate table as required by linking.
I use left outer joins, just because it is easier for me think of while I type the query. It's all about Venn Diagrams, and left is easier for me than right outer joins.
HTH
oh yeah, if you right click on a link between tables you can change the style, it defaults to innner joins, which gives the behavior that you are seening.
IP Logged
