Re: SQL Question

There is no Group Function in the Select Clause.

-Thiru

Mark Wagner wrote:

> This is the insert im trying to do: (PAYROLL_WITH_NO_CUSTOMERIDS is a view)
>
> INSERT INTO DEDUCTEES ( FName, LName, EmployeeID )
> SELECT FName, LName, EmployeeID
> FROM PAYROLL_WITH_NO_CUSTOMERIDS
> GROUP BY FName, LName, EmployeeID
> ORDER BY LName;
>
> this is the response i get:
>
> Oracle8 Release 8.0.5.0.0 - Production
> PL/SQL Release 8.0.5.0.0 - Production
> SQLWKS> INSERT INTO DEDUCTEES ( FName, LName, EmployeeID )
> 2> SELECT FName, LName, EmployeeID
> 3> FROM PAYROLL_WITH_NO_CUSTOMERIDS
> 4> GROUP BY FName, LName, EmployeeID
> 5> ORDER BY LName;
> ORDER BY LName
> *
> ORA-00933: SQL command not properly ended
>
> Im not sure what is wrong.......
>
> thanks
>
> Mark
> mark_at_cybertrails.com
Received on Thu Jul 08 1999 - 14:25:13 CDT