J C
asked on
SQL filtering issue
My WHERE clause in my query must have faulty logic.
The second part of my filter works but the first part is ignored. Is there a way to structure this so that I can get the desired result?
WHERE (rems.project.hidden = 0) AND (NOT (rems.jobsalesexti.prodcode IN ('0000Base', 'ELEVA', 'ELEVB', 'ELEVC', 'EXTCOL'))) AND (rems.jobsalesexts.paycode = '') OR
(rems.jobsalesexts.paycode = 'Draw 1')
The second part of my filter works but the first part is ignored. Is there a way to structure this so that I can get the desired result?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I'm sorry...You're solution did resolve my problem. Thank you!
ASKER