FULL JOIN in Access 2003

[Branislav Vidovic]

Hello everyone! I wonder is it possible to create SQL querie using FULL JOIN in Access 2003? When i try it i just get syntax error. So does anyone have an idea how to simulate full join in access? Cheers!

[Blue_Boy]

Branislav Vidovic wrote:

When i try it i just get syntax error

Which error message do you get? Post your code to see where is wrong. For more about FULL JOIN.[^]

---

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com

[Jerry Hammond]

There is no reason to simulate the Outer Join. Please post your query along with the error you receive.

"My interest is in the future because I'm going to spend the rest of my life there." - Charles F. Kettering

[riced]

Possibly the union of a left join and a right join? :)

Regards David R --------------------------------------------------------------- "Every program eventually becomes rococo, and then rubble." - Alan Perlis

[Baran M]

you can refer this and read the comments also plz [^]

Education is not a way to escape poverty — it is a way of fighting it.

[Branislav Vidovic]

Yes I actually tried that and made it. IT is actually union of left join, right join and inner join :D

[riced]

Branislav Vidovic wrote:

and inner join

Of course - stupid of me to forget it. :)

Regards David R --------------------------------------------------------------- "Every program eventually becomes rococo, and then rubble." - Alan Perlis