Re: Error in Query - need help

From: Vishal Parkar (REMOVE_THIS_vgparkar_at_yahoo.co.in)
Date: 03/15/04 

Date: Tue, 16 Mar 2004 03:41:31 +0530

Try: (see comment on the last line)

SELECT A1.EecSupervisorID,
A1.EecEmplStatus,
CC.EecEmpNo,
'1' AS Approver
INTO EmpLoad.dbo.Tbl_Approver
FROM
(frdhrdb1.ultipro_lti.dbo.EmpComp as A1
 INNER JOIN frdhrdb1.ultipro_lti.dbo.EmpPers as BB
ON A1.EecSupervisorID = BB.EepEEID)
 LEFT JOIN frdhrdb1.ultipro_lti.dbo.EmpComp AS CC ON
BB.EepEEID = CC.EecEEID
GROUP BY A1.EecSupervisorID, A1.EecEmplStatus, CC.EecEmpNo

HAVING (((A1.EecEmplStatus)='A')); --should be single quote. 

-- 
Vishal Parkar
vgparkar@yahoo.co.in