getting error in query..

[rajesh0303]

Query gives error : Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression

Query is :
select AlertGroupAssig nment.AlertGrou pAssignmentID,O PCAlert.AlertID ,OPCServer.OPCS erver,OPCItem.O PCItem,OPCAlert .AlertType,OPCA lert.AlertValue ,OPCAlert.Sever ity,OPCAlert.Ac tive,OPCAlert.D escription from OPCAlert,AlertG roupAssignment, OPCItem,OPCServ er where AlertGroupAssig nment.AlertGrou pID=3 and AlertGroupAssig nment.OPCAlertI D!=(select OPCAlertID from AlertGroupAssig nment where AlertGroupID=1) and OPCAlert.AlertI D=AlertGroupAss ignment.OPCAler tID and OPCItem.ItemID= AlertGroupAssig nment.OPCItemID and OPCServer.Serve rID=OPCItem.Ser verID or (OPCAlert.Descr iption like 'dgv' or OPCItem.OPCItem like 'dgv' or OPCServer.OPCSe rver like 'dgv')


I want to return more than 1 value.....Is there any way....

Please help........

[deepuv04]

Use "NOT IN " instead of " != "

Try the following query

[code=sql]

SELECT AlertGroupAssig nment.AlertGrou pAssignmentID,O PCAle rt.AlertID,OPCS erver.OPCServer ,
OPCItem.OPCItem ,OPC Alert.AlertType ,OPCAlert.Alert Value,OPCAlert. Sever ity,OPCAlert.Ac tive,
OPCAlert.Descri ption
FROM OPCAlert,
AlertGroupAssig nment,
OPCItem,
OPCServer
WHERE AlertGroupAssig nment.AlertGrou pID=3 and
AlertGroupAssig nment.OPCAlertI D NOT IN(SELECT OPCAlertID FROM AlertGroupAssig nment WHERE AlertGroupID=1) and
OPCAlert.AlertI D=AlertGroupAss ignment.OPCAler tID and
OPCItem.ItemID= AlertGroupAssig nment.OPCItemID and
OPCServer.Serve rID=OPCItem.Ser verID or
(OPCAlert.Descr iption like 'dgv' or OPCItem.OPCItem like 'dgv' or OPCServer.OPCSe rver like 'dgv')
[/code]

[rajesh0303]

Thanks Man....I was breaking my head on this silly thing for an Hour....

Thanks again,....