Jump to content
Jim R

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

Recommended Posts

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.  

Share this post


Link to post
Share on other sites

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

  • Like 1

Share this post


Link to post
Share on other sites

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

  • Like 1

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.