Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> SQL Question
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;
Im not sure what is wrong.......
thanks
Mark
mark_at_cybertrails.com
Received on Thu Jul 08 1999 - 13:59:49 CDT
![]() |
![]() |