Select by Attributes: AND...AND

M_ST

Hi, I would like to run a query that includes multiple codes of a field, like Selection: Where clc_18 is equal to (Number) AND clc_18 is equal to (Number) ....But no results were found. What did I do wrong?

Selection_CLC.png

Luke_Pinner

Your query is requesting rows where each entry in the clc_18 field is both one value and a different value at the same time.  That will always return no rows.

Use OR instead of AND, e.g clc_18 = Number OR clc_18 = Another Number

Or use the IN operator, e.g clc_18 IN (Number, Another Number, Some Other Number)