Re: Fish out of water (SQL Script error)

From: Sanjay Raj <rsanjaynj_at_yahoo.com>
Date: 8 Jun 2001 06:48:31 -0700
Message-ID: <9f767483.0106080548.74843102_at_posting.google.com>


"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

I don't think U need a comma (,) after p.project_name because that is the last field U R selecting Received on Fri Jun 08 2001 - 15:48:31 CEST

Original text of this message