INNER JOIN with Oracle 8i

[hlauwers]

I have the folowwing query:

SELECT COUNT(*) FROM X INNER JOIN Y ON X.OID = Y.OID

When I try to run it via SQL*Plus an error occurs:

.ORA-00933 SQL command not properly ended
the error marks the JOIN keyword


what's wrong?

 

[sem]

Pre-9i Oracle SQL doesn't support JOIN keyword.Try

SELECT COUNT(*) FROM X, Y where X.OID = Y.OID

Regards, Dima

http://seminihin.narod.ru

 

[hlauwers]

Thank you.

And a RIGHT JOIN ... would that be

WHERE X.OID = Y.OID(+)

?

 

[SantaMufasa]

HLauwers,

In Oracle, when you use the "(+)" symbol on an operand of a WHERE clause's relational expression (regardless of whether you put it on the "left" or "right" operand), it produces what we fondly call a "left outer join". The effect is a "join for otherwise 'left-out' records".

I would be interested in hearing one of our Oracle gurus postulate an explanation that focuses meaningfully on the theoretical use of the terms "left" versus "right" and "inner" versus "outer" as they apply to Oracle.

As far as I am aware, at least in the Oracle world, we do not meaningfully use what would appear as the converse terminology: "right-inner" join...It's just a join.

Mufasa
(aka Dave of Sandy, Utah, USA @ 16:12 (10Jun04) UTC (aka "GMT" and "Zulu"), 09:12 (10Jun04) Mountain Time)

 

[hlauwers]

Thanks for the info, SantaMufasa, it helped a lot.