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?

[Luke_Pinner · Accepted solution]

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)

[M_ST]

Thanks! It works without problems. 😁✌️