I am using T-SQL (SQL Server 2000) and I want to exclude customers who meet two different criteria simultaneously. For example below:
Select * from Customers
State = 'New York'
The problem is I don't want to exclude all Customers who state = 'New York'
only those customers that meet both criteria do I want to exclude. Any ideas on how to do this? Thanks for the help.