Jump to content

OR problem


piznac

Recommended Posts

hey guys,

Im having a problem that should be easy:

[code]SELECT *
FROM subjob
WHERE 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?
Link to comment
Share on other sites

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]
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

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.