Quick simple query

L

luis.a.roman

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
 
V

Van T. Dinh

I am only guessing since I don't know Oracle SQL

SELECT A.Requirement, B.Number
FROM AllRequirement AS A LEFT JOIN Account AS B
ON A.LinkField = B.CorrespondingLinkField.
 
S

Steve Schapel

Luis,

I know nothing about Oracle, but I think you might mean like this...

SELECT allRequirement.requirement, account.number
FROM allRequirement LEFT JOIN account
ON allRequirement.requirement = account.number;
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top