Outer Join more than two tables. Possible?

[Guest]

Hi,
I'm used to design queries in VB with Sybase as the datasource. I'm now
trying to construct a query with Access as the source to execute in a VB
programme through ADO. Because of the useless complexity of Access sql-query
code when joining multiple tables I'm forced to let the sql code be generated
for me by the Access Query builder, so I can convert it manually to VB-code.
I need to Outer Join 5 tables to one table but when trying to execute a query
with more than one Outer Join I get an error message saying more than one
Outer Join is impossible.

1.) Is there a workaround for Outer joining multible tables in Access?

2.) What's the best way for constructing Access SQL-code? Using the Access
Query builder or is there another way? Designing it manually in VB drives me
crazy because of all the brackets when joining tables.

Thanks in advance,
E. Froma

 

[Guest]

A useful rule to follow when doing multiple outer joins is this...

Once you have an outer join, all other tables linked on the "downstream"
side of the join (in the direction of the arrow) must also be outer joins.

To get around this, if you need to, create a separate query linking the
downstream tables with their inner or right joins, then use this as a
subquery in your main query