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-