Re: INNER JOIN

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" <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 - 15:11:01 CET