Fish out of water (SQL Script error)
Date: Sat, 2 Jun 2001 10:03:45 -0700
Message-ID: <3b190ea5$0$766$e2e8da3_at_nntp.cts.com>
Hi,
I'm practicing for the first test, SQL, and I have come up to an error in running this simple query. I don't believe that I am missing and expression as Oracle suggests. However, there may be and expression used in older versions that could be used to bypass the problem. Or, the course work I've taken may have left an expression out. Could some one help me in determining why the query returns an ORA-00936 error code?
2 p.project_name, 3 FROM employee e, 4 project p, 5 project_hours ph 6 WHERE e.employee_id = ph.employee_id 7 AND p.project_id = ph.project_id 8 GROUP BY e.employee_id, e.employee_name, 9 p.project_id, p.project_name; FROM employee e,
*
ERROR at line 3: ORA-00936: missing expression
SQL*Plus: Release 8.1.7.0.0 - Production on Sat Jun 2 09:47:07 2001
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Received on Sat Jun 02 2001 - 19:03:45 CEST