From: youngbar@insightbb.com   
      
   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   
      
      
      
   "Hans Forbrich"  wrote in message   
   news:3FEE4824.36EB0ACB@yahoo.net...   
   > > Barry Young wrote:   
   > >   
   > > I am using Access to create a SQL query. It creates an Inner Join   
   > > Query.  I cut and paste the query into PL-SQL. When I try to execute   
   > > the query I get an error.   
   > >   
   > > ORA 933 SQL command not properly ended.   
   > >   
   > > It highlights the INNER JOIN statement on the SQL command.   
   > >   
   > > Can someone recommend a utility to convert these Microsoft or Access   
   > > SQL queries to PL SQL?   
   > >   
   > > Thanks!   
   > >   
   >   
   > Please post your SQL statement, and the target Oracle version.  If it's   
   > proper SQL it should run on plain Oracle (since Oracle runs as close to   
   > the standard as any) but the version number is certainly a big help.   
   >   
   > Ana C. Dent suggested adding a line with a slash "/" as the only thing   
   > on the line.  No leading or trailing charaters (not even a blank).   
   > Something like   
   >   
   > SELECT * FROM TAB   
   > /   
   >   
   > or   
   >   
   > SELECT TNAME   
   >   FROM TAB   
   > /   
   >   
   >   
   > Please note, PL/SQL is Oracle's procedural programming language (doing   
   > roughly the same as Sybase's Transact-SQL (AKA Microsoft's T-SQL)).   
   > These languages try to put procedural stuff (sequential statements,   
   > loops, conditions, etc) around SQL.  I suspect you are trying to use   
   > plain SQL rather than the slightly more complex PL/SQL.   
   >   
   > HTH   
   > /Hans   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)