Home » SQL & PL/SQL » SQL & PL/SQL » SQL join 3 tables (TNS for Solaris: Version 8.1.7.0.0 - Production)
SQL join 3 tables [message #284394] Thu, 29 November 2007 09:11 Go to next message
jriggs
Messages: 12
Registered: October 2007
Junior Member
I'm working on a query that will return data from 3 tables. Eventually I need to add more columns and where/order clauses, but I can't get the basic query down.

SELECT to_be_shipped.ordernum, orders.ordernum, ccinfo.ordernum
FROM to_be_shipped JOIN orders ON (to_be_shipped.ordernum=orders.ordernum)
JOIN ccinfo ON (to_be_shipped.ordernum=ccinfo.ordernum);

==================================================
from to_be_shipped join orders on 
                        *
ERROR at line 2:
ORA-00933: SQL command not properly ended


any suggestions, thanks in advance-
Re: SQL join 3 tables [message #284398 is a reply to message #284394] Thu, 29 November 2007 09:17 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ANSI syntax was not available in 8i.

Regards
Michel
Previous Topic: Stored procedure to convert long raw to blob > 32k
Next Topic: Oracle dbms_job.submit
Goto Forum:
  


Current Time: Sun Dec 04 16:29:03 CST 2016

Total time taken to generate the page: 0.05798 seconds