Re: SQL Question

The 'group by' clause is also unnecessary since there are no summary columns.

Ken

Alex Shnir wrote:

> removal of order by clause will fix it
>
> 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 Fri Jul 09 1999 - 06:46:33 CDT