Re: INNER JOIN

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sat, 27 Dec 2003 17:36:59 -0800
Message-ID: <0tqHb.41585$BQ5.35902_at_fed1read03>


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?

In many cases what is needed another line following the end for the SQL-statement. This line should contain a single "/" as the leftmost and only character on the line

HTH & YMMV Received on Sun Dec 28 2003 - 02:36:59 CET

Original text of this message