sql server mseq: I get the following strange error when executing the query
below. Can anyone help me find the error ? thanks in
advance.



Server: Msg 207, Level 16, State 3, Line 1
Invalid column name 'A'.
----------------------------------------

Query:


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"));

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