Posted by: Anonymous Coward
on September 17, 2002 02:25 AM
Here's an example on an Oracle system I work with. I'm no expert, but I tried what the author was saying and he seemed to be right.
database version: ----------------- Connected to: Oracle8i Enterprise Edition Release 8.1.7.1.0 - Production
query: ------ SQL> select international.internationalId,wobject.wobjectId from international left outer join wobject on international.namespace=wobject.namespace;
error: ------ ERROR at line 1: ORA-00933: SQL command not properly ended
Note: The little * in the SQL Plus interface was right under the join syntax. I don't think I did anything wrong.
Learn about Linux
Download Linux
Get Linux help
Re:Oracle supports ANSI99 outer join syntax
Posted by: Anonymous Coward on September 17, 2002 02:25 AMdatabase version:
-----------------
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.1.0 - Production
query:
------
SQL> select international.internationalId,wobject.wobjectId from international left outer join wobject on international.namespace=wobject.namespace;
error:
------
ERROR at line 1:
ORA-00933: SQL command not properly ended
Note: The little * in the SQL Plus interface was right under the join syntax. I don't think I did anything wrong.
#