Convert Oracle Query to MS-Access

[M Riaz Bashir]

Hi, Kindly let me know how may I convert following Oracle sql into MS-Access ?

SELECT A.SNO, A.CODE, A.QTY, A.RATE, B.NAME
FROM DETAIL A, MASTER B
WHERE A.CODE=B.CODE(+)

thanx in advance

[Mycroft Holmes]

This should wok, I'm not sure what the significance of (+) is in the join

SELECT A.SNO, A.CODE, A.QTY, A.RATE, B.NAME
FROM DETAIL A
INNER JOIN MASTER B ON A.CODE=B.CODE

[Jorgen Andersson]

M Riaz Bashir wrote:

Kindly let me know how may I convert following Oracle sql into MS-Access ?

Why, would anyone ever move from oracle to access? Anyway, here goes.

SELECT A.SNO, A.CODE, A.QTY, A.RATE, B.NAME
FROM DETAIL A RIGHT JOIN MASTER B
WHERE A.CODE=B.CODE

[Jorgen Andersson]

The (+) makes it an outer join.

[David Skelly]

I think it's a left join, not a right join. I'm not an Oracle expert but I have a feeling the (+) goes on the side of the join which is not required (not sure of the technical term for that). In other words

a.code = b.code(+)

is a left outer join and

a.code(+) = b.code

is a right outer join. I'm not 100% sure about that so don't take my word for it.

[Jorgen Andersson]

Damn! I need a coffee. Or actually rather a beer. Or both.

[Chris Meech]

a.code = b.code(+)

The (+) says any a.code value will match a NULL b.code value. Meaning you get all the a.code values.

Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]