Re: INNER JOIN

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" <forbrich_at_yahoo.net> wrote in message news:3FEE4824.36EB0ACB_at_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
Received on Sun Dec 28 2003 - 04:39:14 CET