Re: Fish out of water (SQL Script error)

you have an extra comma at the end of line 2

"Philippe L. Balmanno" <plb2862_at_cts.com> wrote in message news: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?
>
> Thanks in advance,
>
> SQL> SELECT e.employee_name,
> 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 - 20:43:12 CEST