QUERY IN ACCESS

[joe]

Hi,

I am working on a database with employee details in Access. I need to write
a outer join query. But I know access does not support outer join query, is
there any other code which is equal to outer join? If anyone can send a
sample that would be a real help.

Thanks,

 

[John Vinson]

Hi,

I am working on a database with employee details in Access. I need to write
a outer join query. But I know access does not support outer join query, is
there any other code which is equal to outer join? If anyone can send a
sample that would be a real help.

Thanks,

Access does support Left Outer Join and Right Outer Join queries - and
you can simulate a Full Outer Join by combining these with UNION:

SELECT TableA.*, TableB.*
FROM TableA LEFT JOIN TableB
ON TableA.fieldname = TableB.fieldname
UNION
SELECT TableA.*, TableB.*
FROM TableA RIGHT JOIN TableB
ON TableA.fieldname = TableB.fieldname;


John W. Vinson[MVP]