This is driving me crazy. I am trying to select all records except for ones that match a certain criteria. Here's some set up:
Here's a sample of a table I'm working with:
Let's say I want to select everything where Acct does not equal 02002150B and Uniq does not equal 225. I write a query like this:
SELECT * from something where (Acct != '02002150B' AND Uniq != '225' )
If I run this query, the results returned are as follows:
Both accounts with the Uniq value of 225 are missing even though I requested a specific Acct number.
What's driving me crazy is that if I were to switch from != to =, the query returns only one result, which is exactly what I would expect it to do.
How can I write a query to return only these results?:
Thanks for reading. I appreciate your time.