outer join with ACCESS 
Author Message
 outer join with ACCESS

Hi !

What's the syntax for an outer join in the ACCESS SQL ?

Sylvain



Sat, 13 Nov 2004 00:09:51 GMT  
 outer join with ACCESS
On Mon, 27 May 2002 18:09:51 +0200, "Sylvain Deuwel"

Quote:

>Hi !

>What's the syntax for an outer join in the ACCESS SQL ?

Only Left and Right outer joins are supported; you can't directly do a
Full Outer Join.

SELECT <whatever>
FROM A [LEFT|RIGHT] JOIN B ON [A].[ID] = [B].[ID];

To get a Full Outer Join you must create separate LEFT and RIGHT outer
joins as queries, and use a UNION query to combine the records.

                  John W. Vinson[MVP]    
    Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public



Sat, 13 Nov 2004 02:52:58 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Access 2000 -Full Outer Join

2. Access OUTER JOIN syntax

3. Access left outer join or handling no records found

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

5. Outer Joins

6. How DAO works with outer join query with Parameter

7. No outer joins with Jet 4 drivers?

8. sql poser: OUTER JOINS?

9. SQL Builder - Outer Joins.

10. E_FAIL when outer-joining

11. Ambiguous Outer Joins....

12. SQL Builder - Outer Joins.

 

 
Powered by phpBB® Forum Software