Home » SQL & PL/SQL » SQL & PL/SQL » SQL join 3 tables (TNS for Solaris: Version - Production)
SQL join 3 tables [message #284394] Thu, 29 November 2007 09:11 Go to next message
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: 65086
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ANSI syntax was not available in 8i.

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

Current Time: Tue Jul 25 08:02:52 CDT 2017

Total time taken to generate the page: 0.06232 seconds