getting error in query..

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 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!=(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')


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

Please help........

re: getting error in query..

Use "NOT IN " instead of " != "

Try the following query

re: getting error in query..

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

Thanks again,....