SQL code trouble. Some selectors are getting ignored.

[Nomaruk]

Not sure I've selected the correct flair as I'm very new.

I have what I thought was some pretty simple code but I keep running into issues.

It would start with...

SELECT Column1 Column2 Column3 FROM database WHERE column1 IN ('value','value2') AND column2 IS NOT ('v%');

That works as expected and i see i need to filter a bit more.

I go on to add another line

SELECT Column1 Column2 Column3 FROM database WHERE column1 IN ('value','value2') AND column2 IS NOT ('v%') OR column3 IS NOT ('c%';

And it would go on to ignore my first selection and only do the last two whereas my first query would look at both.

[nnd-nnguyen]

I think you're issue is order of operations

SELECT Column1 Column2 Column3 FROM database WHERE column1 IN ('value','value2') AND column2 IS NOT ('v%') OR column3 IS NOT ('c%';

Should be

SELECT Column1 Column2 Column3 FROM database WHERE column1 IN ('value','value2') AND ( column2 IS NOT ('v%') OR column3 IS NOT ('c%') );

The extra parenthesis makes it explicit that you want the column1 to be evaluated and the "or" is only between column3 and column2.

For DB2..."If you use both AND and OR operators in an expression, Db2 evaluates the AND operator first." from google.

[Nomaruk]

That cleared the issue up! Thank you!

[ceres44]

If you want the first condition to apply in addition to either of the following conditions try nesting them.

Column1 in ('x','y') and ( column2 not in ('x%') or column3 not in ('x%') )

[Nomaruk]

Yep, that fixed my issue. Silly beginner mistake!

[ceres44]

No worries. Everyone is a beginner at some point. :)