I had my table joined with another one which share common IDs'.
But I found that I could not perform well for 'select by attribute' in the joined table.
I tried to select polygons of specific attributes, but the result showed wrong selections.
Is there an workaround to solve that issue?
Could you provide some more information?
Screenshots would be great but also could include any information related to the specific software you are using as well as the layers you have joined?
I've solved that issue. I used Arcmap 10.7 while using gssurgo data of USDA (soil data)
Each original shape soil survey database. Each shape/raster file for U.S state has its own attribute tables in the database.
The problem was my AOI is boundary area of multiple U.S states, so I had to merge them into one.
The merged table (of original shape file) was joined with its attribute tables. But the Arcmap could not select rows with given attributes.
So I used Join Field function (Data Management tools>Joins>Join Field) for original shape files.
After that a merged/clipped shape file worked well.
Thanks for your advice. I will add more explanation to clarify in next time.