How to use an Oracle query in MS ACCESS 1

[liezlm]

I have very little experience in Access so this is really hard for me. My Oracle SQL query is:

SELECT t3.active, t3.col, t1.town, t2.name 
FROM table1 t1, table2 t2, table3 t3
WHERE t1.val_id = t3.val_id (+)
and t1.appl_id = t3.appl_id
and t1.coname_id = t2.coname_id
;

How do i code this is Access?

This is what i have and it does not work:
SELECT table3.active, table3.col, table1.town, table2.name
FROM ( (table1) left join table3 on table1.val_id = table3.val_id ) inner join table2 on table1.coname_id = table2.coname_id

Thank you in advance for your assistance.

 

[PHV]

Perhaps this ?

SELECT t3.active, t3.col, t1.town, t2.name
FROM (table1 t1
INNER JOIN table2 t2 ON t1.coname_id = t2.coname_id)
LEFT JOIN table3 t3 ON t1.val_id = t3.val_id AND t1.appl_id = t3.appl_id

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[liezlm]

That's perfect PHV! Thanks a lot for your help.