Im having a problem that should be easy:
SELECT * FROM subjob WHERE pname = 'PHP Get Parameter' AND subjob.markcomplate != 'Y' OR subjob.markcomplate IS NULL
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?