If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Outer Join more than two tables. Possible?
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 |
#2
|
|||
|
|||
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 "E. Froma" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Calculated Value will not store in Table | tonyaims | Using Forms | 10 | September 14th, 2004 03:11 AM |
outer join help | Shanin | Running & Setting Up Queries | 6 | July 27th, 2004 08:40 PM |
cross join? full join? or something like that? | Alejandra Parra | Running & Setting Up Queries | 1 | June 17th, 2004 06:22 AM |
How to join contiguous tables into one table | Uncle Bill | Tables | 3 | June 12th, 2004 04:46 PM |