https://community.esri.com/t5/arcgis-pro-questions/select-by-attributes-and-and/m-p/1217854#M60570 <P>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?</P> Fri, 30 Sep 2022 12:44:46 GMT M_ST 2022-09-30T12:44:46Z https://community.esri.com/t5/arcgis-pro-questions/select-by-attributes-and-and/m-p/1217854#M60570 <P>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?</P> Fri, 30 Sep 2022 12:44:46 GMT https://community.esri.com/t5/arcgis-pro-questions/select-by-attributes-and-and/m-p/1217854#M60570 M_ST 2022-09-30T12:44:46Z https://community.esri.com/t5/arcgis-pro-questions/select-by-attributes-and-and/m-p/1217858#M60571 <P>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.&nbsp; That will always return no rows.</P><P>Use OR instead of AND, e.g&nbsp;<SPAN>clc_18 = Number OR clc_18 = Another Number</SPAN></P><P>Or use the IN operator, e.g&nbsp;<SPAN>clc_18 IN (Number, Another Number, Some Other Number)</SPAN></P><P>&nbsp;</P><P>&nbsp;</P> Fri, 30 Sep 2022 12:58:56 GMT https://community.esri.com/t5/arcgis-pro-questions/select-by-attributes-and-and/m-p/1217858#M60571 Luke_Pinner 2022-09-30T12:58:56Z https://community.esri.com/t5/arcgis-pro-questions/select-by-attributes-and-and/m-p/1217870#M60575 <P>Thanks! It works without problems. <span class="lia-unicode-emoji" title=":beaming_face_with_smiling_eyes:">😁</span><span class="lia-unicode-emoji" title=":victory_hand:">✌️</span></P> Fri, 30 Sep 2022 13:23:08 GMT https://community.esri.com/t5/arcgis-pro-questions/select-by-attributes-and-and/m-p/1217870#M60575 M_ST 2022-09-30T13:23:08Z