Jump to content

Archived

This topic is now archived and is closed to further replies.

piznac

OR problem

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?

Share this post


Link to post
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]

Share this post


Link to post
Share on other sites

×

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.