Re: INNER JOIN

Barry Young wrote:
>
> Hans,
>
> Well I think what appears to be the problem is that Pre Oracle 9i does not
> support the INNER JOIN. I am using 8i so I will have to restructure the SQL
> query similar to this:
>
> SQL> SELECT c.course_name, c.period, e.student_name
> 2 FROM course c, enrollment e
> 3 WHERE c.course_name = e.course_name
> 4 AND c.period = e.period;
>
> I thought INNER JOINS were an ANSI SQL standard. I was surprised that
> ORACLE doesn't support the INNER JOIN. Unless I am wrong.
>
> Barry
>

The new JOIN syntax is not available below Oracle9i.

As for being an ANSI SQL standard, you are likely running into a timing issue, as follows:

Oracle8 series (which ends with Oracle8i Release 3 or 8.1.7.x) was released around 1997. Flip side, ANSI SQL has had 3 major revisions - '87 (IIRC), '92 and '99. If I'm not mistaken, that JOIN syntax was introduced in SQL '92 (but had holes) and was completed in '99. Not the kind of thing I'd hold against Oracle, especially since there was a perfectly acceptable workaround.

All the more reason to move to Oracle9i. Especially since Oracle did announce End of Life for 8i. Received on Sun Dec 28 2003 - 23:26:28 CET