SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

JOIN syntax for Oracle 8i

349693Nov 7 2002

I have a SQL statement which looks like this:

SELECT * FROM user.table table LEFT OUTER JOIN user.table2 table2 ON table.column = table2.column;

Which seems to be the right syntax according to the Oracle SQL reference, but when I try and execute it I get the error:

ERROR at line 1:
ORA-00933: SQL command not properly ended

Is there a difference between 9i and 8i syntax?

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 5 2002

Added on Nov 7 2002

6 comments

735 views