From: forbrich@yahoo.net   
      
   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.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)