SQL Query Help -Multiple Joins?

[shauntck]

Hey guys, i've got basically 5 tables for this query.

Basically I want all records from Table A and if Tables B, C, D, E have the corresponding key i want those records also. However, sometimes I will have records in B but not C, and vice versa ..or C and D...etc.

So i think I want Table A left outer join B, C, D, E right?

-Shaunt

 

[Crowley16]

well, since ur using access, why not use the query builder to do this, and then edit the result if needed...

I find it's much easier that way...

Procrastinate Now!