Access OUTER JOIN syntax 
Author Message
 Access OUTER JOIN syntax

Hi all.

Is there any way to do the equivalent of the following SQL-Server statement
using Access 2.0 ODBC 2.0 connection from VB3.0?

The SQL-Server statement is:
1:    SELECT a.*, b.*, c.*
2:    FROM main AS a, extra1 AS b, extra2 AS c
3:    WHERE a.x *= b.x
4:    AND a.y = b.y

Line 3 is a LEFT OUTER JOIN while line 4 is a typical WHERE statement.
SQL server joins the two no problem.
Access however, uses ANSI syntas for LEFT OUTER JOINs, and I'm having
problems implementing the above statement in Access SQL.
So far I have gotten past the problem by changinc line 4 to an OUER JOIN also.

Does anyone know if the above statement is possible in Access SQL?

Please respond if you have any knowledge of this...

Thank you,

Asgeir K. Antonsson

Fri, 14 Nov 1997 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Outer Join Syntax

2. SQL Syntax for an Outer Join

3. outer join with ACCESS

4. Access 2000 -Full Outer Join

5. Access left outer join or handling no records found

6. Full Outer Join w/ DAO + Access??

7. Outer Joins

8. How DAO works with outer join query with Parameter

9. No outer joins with Jet 4 drivers?

10. sql poser: OUTER JOINS?

11. SQL Builder - Outer Joins.

12. E_FAIL when outer-joining


Powered by phpBB® Forum Software