outside joins (many-to-many)

[Guest]

I need an outside join or many-to-many join
I have two lists, most of which have the same data, but both with different data. I want the union between the two

Table1 = Query3
Table2 = Query3
the field i want to join is called id

I have something like this

SELECT Query3a.id, Query3b.i
FROM ( ( SELECT id FROM Query3
UNIO
SELECT id FROM Query3b) As

LEFT JOIN Query3a ON c.id = a.i
) LEFT JOIN Query3b ON c.id = b.i

Which doesn't work and probably indicates that I'm lost

Any help? Neither are particular big lists..

Marcus.

 

[Chris2]

The Query:

SELECT Query3a.id
,Query3b.id
FROM ((SELECT id
FROM Query3a
UNION
SELECT id
FROM Query3b) As c
LEFT JOIN Query3a
ON c.id = a.id)
LEFT JOIN Query3b
ON c.id = b.id

aliases are used, a.id & b.id, but "a" and "b" aren't established.

This:

SELECT Query3a.id
,Query3b.id
FROM Query3b AS b
LEFT JOIN
((SELECT id
FROM Query3a
UNION
SELECT id
FROM Query3b) As c
LEFT JOIN Query3a As a
ON c.id = a.id)
ON c.id = b.id

Removes the syntax error generated by the initial query, i.e., Access will
save the Query. I didn't go any further, as I've no idea what else was
being done.

I need an outside join or many-to-many join.
I have two lists, most of which have the same data, but both with

different data. I want the union between the two.