piznac Posted October 26, 2006 Share Posted October 26, 2006 hey guys,Im having a problem that should be easy:[code]SELECT *FROM subjobWHERE pname = 'PHP Get Parameter' AND subjob.markcomplate != 'Y' OR subjob.markcomplate IS NULL [/code] well I need this to give me the results filtered by the project name (pname) then filter it again by "markcomplete" not equaling 'Y'. But it would seem if that field is NULL then it won't return it. Strange but oh well,.. so I put in the OR statement and of course now its ignoring the first statement as long as that field is NULL,.. How would I do this correctly? Quote Link to comment Share on other sites More sharing options...
obsidian Posted October 26, 2006 Share Posted October 26, 2006 When dealing with AND and OR in the same query, you need to show precedence by using parenthesis around the parts of the query you want grouped:[code]SELECT * FROM subjob WHERE pname = 'PHP Get Parameter AND (subjob.markcomplete != 'Y' OR subjob.markcomplete IS NULL[/code] Quote Link to comment Share on other sites More sharing options...
piznac Posted October 26, 2006 Author Share Posted October 26, 2006 AH HA,... knew it had to be something simple. Thanks much! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.