Full Outer Join - Access97 ??

[spiralmind]

Is it possible to create a query or SQL statement using a full outer join in Access 97?
I need to retrieve all records from both of the tables being joined - and not just those records which match along the joined field in both tables, or all records from one table and only matching records in the other.
If full outer joins are possible, can you please suggest the correct SQL syntax to use them? If not, do you have any ideas for a workaround? (Perhaps some sort of subtractive logic or intermediate process?)
- Thankyou

 

[r937]

do a union of two outer joins, one with matching records and one without, e.g.

select a.id, a.column1, b.column2
from a
left outer join b
on a.id = b.id
union all
select a.id, a.column1, b.column2
from b
left outer join a
on b.id = a.id
where a.id is null

sometimes the second query is written as a right outer join, but it's not necessary

the first subquery gets all rows of a, including any matches, while the second subquery gets all unmatched rows of b

the result is a full outer join

rudy