Query Format change for Access

[shabar]

Hi All

I need following query to run on access. But the issue is syntax



This query runs in Oracle



SELECT t1.col11, t3.col32, t2.col22, t2.col23FROM t1, t2, t3WHERE t1.col11 = t3.col31AND t3.col32 = t2.col21 (+)


Cheers

Shabar

[June7]

Did you use Access Query Designer to build query?

[shabar]

You reckon it's easy way..

I'll try

Cheers

Shabar

[shabar]

Hi

How can I create full outer join through Query Designer. I find there only inner and left and right outer join



Cheers


Shabar

[June7]

What do you mean by 'full outer join'. I know only INNER, LEFT, RIGHT, or no join specified at all. In the last case every record of each table will join to every record of other table.

[shabar]

Hi June7

I am after something like this

Tables

AA BB
-------- --------
Item 1 Item 3
Item 2 Item 4
Item 3 Item 5
Item 4 Item 6




Output


AA BB
-------- --------
Item 1
Item 2
Item 3 Item 3
Item 4 Item 4
---- Item 5
---- Item 6


Cheers

Shabar

[June7]

You don't have a 'master' table that has all possible Items?

Query1:
SELECT AA.Item, BB.Item FROM BB RIGHT JOIN AA ON BB.Item = AA.Item;

Query2:
SELECT AA.Item, BB.Item FROM AA RIGHT JOIN BB ON AA.Item = BB.Item;

Query3:
SELECT * FROM Query1
UNION SELECT * FROM QUery2;

or All in One:
SELECT AA.Item, BB.Item FROM BB RIGHT JOIN AA ON BB.Item = AA.Item
UNION SELECT AA.Item, BB.Item FROM AA RIGHT JOIN BB ON AA.Item = BB.Item;

There is no wizard or designer for UNION, must type in SQL VIEW.

[shabar]

Thax mate

Cheers