I can't get a full outer join to work

[Bobt1993]

Can someone tell me what I'm doing wrong?

I have two tables joined by a key and the following statement does not work:

select * from acct a full outer join transactions t on (t.acctid = a.id)

When I try to execute this query, I get: "Syntax Error in FROM Clause".

[maximus]

Outer join not supported by access, Create a union of a left and a right join.

[Bobt1993]

Thanks!

Actually, I did some further research and found another blog that addresses the "full outer join not supported by Access" issue, complete with a workaround.

I'm new to MS SQL after having been mostly an Oracle developer for the past 5 years, and I use full joins all the time. I was surprised to see it not work in Access. I guess it doesn't work in MS SQL Server either?

[maximus]

mark the thread solved please!!!