SQL Question

From: Mark Wagner <mark_at_cybertrails.com>
Date: Thu, 8 Jul 1999 11:59:49 -0700
Message-ID: <0L6h3.175$3X4.4153586704@mick.cybertrails.com>

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 - 13:59:49 CDT