Simple query question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Try this --
Select a.requirement, b.number
from a LEFT JOIN b ON a.requirement = b.requirement;
 
Back
Top