From: youngbar@insightbb.com   
      
   Hello Hans,   
      
   Here is an example statement:   
      
   SELECT Table1.StartDate, Table2.Description   
   FROM Table1 INNER JOIN Table2 ON Table1.ID = Table2.ID;   
      
   INNER JOIN is what is giving me the ORA 933 SQL command not properly ended.   
      
   This is just a piece of the code.. In the final statement there will be   
   NESTED INNER JOINS..  So I may have to do Unions??   
      
   Any help would be appreciated.   
      
   Thanks!   
      
   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)