Simple query question

[101287]

In oracle 9i I can execute the query below and give me all the requirements in table a eventhough there is not match on the other table b, how can I do that in access.

Select a.requirement, b.number
from allREquirement a, account b
where a.requirement(+) = b.number;

I tried this query in access and did not work.

Your guidance will be appreciated.

Luis

 

[PHV]

SELECT a.requirement, b.number
FROM allREquirement a LEFT JOIN account b ON a.requirement = b.number

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886