two comparison <> combined

[GROKING]

Hello,

Trying to combine two not equals together where the combo is a set.
I am trying this in mysql 5.1 with wrong intended results.

select *
from ab_test
where ((test_name <> 'WinBuyer') and (isactive <> 'true'))

Results wanted
test_name 'George' and isactive 'true'
test_nmae 'Fred' and isactvie 'false'

Any ideas on this would be helpful.

May need a subquery?

Thanks

 

[r937]

try OR instead of AND

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon