Access 2003 help says you can do full outer join, but user interf.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Help seems not to match Access 2003.
What I want to do is a full outer join.
Does Access 2003 support this?
How is it done, if so?
 
Hi,


Jet does not support FULL outer join directly. You can try:


SELECT a.*. b.*
FROM a LEFT JOIN b
ON a.f1=b.f1

UNION ALL

SELECT a.*, b.*
FROM a RIGHT JONI b
ON a.f1=b.f1
WHERE a.fi IS NULL



or



SELECT a.*, b.*
FROM (( SELECT f1 FROM a
UNION
SELECT f1 FROM b) As x

LEFT JOIN a ON x.f1=a.f1 )
LEFT JOIN b ON x.f1=b.f1



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top