More Complex Queries—And’s and Or’s
Perhaps you are confused about AND’s and OR’s—like why you get both the left polygons and the top polygons when you use the expression
[LOCATION] =‘LEFT’ OR [PLACEMENT] = ‘TOP’
Well, it’s good that you are confused. It will make you think carefully about the Boolean expressions you put in the Query Builder. It is amazingly easy to make a mistake!
For further information click on Help on the Main menu, enter “building SQL expressions”, and press Ask.

Get Introducing Geographic Information Systems with ArcGIS: A Workbook Approach to Learning GIS, 3rd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.