On Mon, 27 May 2002 18:09:51 +0200, "Sylvain Deuwel"
Quote:
>Hi !
>What's the syntax for an outer join in the ACCESS SQL ?
Only Left and Right outer joins are supported; you can't directly do a
Full Outer Join.
SELECT <whatever>
FROM A [LEFT|RIGHT] JOIN B ON [A].[ID] = [B].[ID];
To get a Full Outer Join you must create separate LEFT and RIGHT outer
joins as queries, and use a UNION query to combine the records.
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
outer join with ACCESS