Multiple ANDs and an OR in a WHERE clause...

[Jim R]

SELECT paid,nameFirst,nameLast,college,feet,inches,phoneMobile,email 
FROM college_league_2018 
WHERE confirm ='1' 
AND  teamplayer='player' 
AND (college != 'Wabash' OR college != 'DePauw') 
ORDER BY college, nameLast

 

This seems simple, and I've found a few examples saying to use parentheses.  It's not working.  

I want individuals where...

confirm = 1

teamplayer = player

who don't attend Wabash or DePauw

 

My results still include individuals who attend both schools.  When I remove the OR and just exclude one of the schools, it works.  

[element121]

I would write it like this using IN or rather in this case NOT IN:

AND (college NOT IN ('Wabash','DePauw'))

Does that give you what you are after?

I find it a lot easier to read.

Hope that helps,

Jon

[Barand]

When you are using "not equals" the OR needsd to be an "AND".

Although I agree with element121, "(NOT) IN" is a lot easier than multiple ORs

[Jim R]

Thank you both!