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

 
SELECT    AlertGroupAssignment.AlertGroupAssignmentID,OPCAle rt.AlertID,OPCServer.OPCServer,
        OPCItem.OPCItem,OPC Alert.AlertType,OPCAlert.AlertValue,OPCAlert.Sever ity,OPCAlert.Active,
        OPCAlert.Description 
FROM    OPCAlert,
        AlertGroupAssignment,
        OPCItem,
        OPCServer 
WHERE    AlertGroupAssignment.AlertGroupID=3 and 
        AlertGroupAssignment.OPCAlertID NOT IN(SELECT OPCAlertID FROM AlertGroupAssignment WHERE AlertGroupID=1) and 
        OPCAlert.AlertID=AlertGroupAssignment.OPCAlertID and 
        OPCItem.ItemID=AlertGroupAssignment.OPCItemID and 
        OPCServer.ServerID=OPCItem.ServerID or 
        (OPCAlert.Description like 'dgv' or OPCItem.OPCItem like 'dgv' or OPCServer.OPCServer like 'dgv')
 

[rajesh0303]

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

Thanks again,....