I am looking an outer joint query like following. I just wonder does
MS Access support following query.


Table1
ID
1
2
3

Table2
ID
2
5
6

Can I have an outer joint query to get all records like?

Query Result
1
2
3
5
6

MS Access has Left Outer and Right Outer joint. Does it support Left
and Right Outer Joint together?
If yes, can you show me how to get the query?

Your help is great appreciated,

On Thu, 16 Dec 2010 16:55:29 -0800 (PST), inungh <(E-Mail Removed)> wrote:


>
>MS Access has Left Outer and Right Outer joint. Does it support Left
>and Right Outer Joint together?
>If yes, can you show me how to get the query?

Not directly, but you can construct one using a UNION:

SELECT TableA.ID LEFT JOIN TableB.ID
ON TableA.ID = TableB.ID
UNION
SELECT TableA.ID RIGHT JOIN TableB.ID
ON TableA.ID = TableB.ID

--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/For...-US/accessdev/
http://social.answers.microsoft.com/.../en-US/addbuz/
and see also http://www.utteraccess.com