I have a layer, with two columns called NAME and TYPE. A polygon in the layer has only one NAME, but can contain multiple TYPE of vegetation. I want to select different Types of vegetation, where the name is the same.
Example:
I want to select all the polygons that contain Evergreen AND Dipterocarp.
From the pic the polygon named Doi chiang dao should be selected.
I have tried using the "Select Layer by Attribute" in ArcMap, but I cannot figure out how to create an SQL statement that can do the above-mentioned operation.