nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Select by Attributes from multiple layers

michaelcollins1

I have to update a database (FGDB), and I'm wondering if there's an easy way to use the Select by Attributes or Select Analysis to do it.

Can you use this to select from two layers based on attribute table values, such as "column2" = Layer2.column2 (this doesn't work in particular but you get the idea).

This seems to be something that should be dead easy but I'm at a loss.

Thanks

Mike

Find more posts tagged with

Accepted answers

michaelcollins1

Thanks, but I was looking for the Selection by Attributes to do the following:

Select * from Existing, New
where Existing.Object_ID = New.Object_ID

It doesn't look like it's capable of that. I was just looking for a quick solution. I'll have to join the 2 and select from there.

thanks again.

All comments

LucasBannan2

If I understand your question correctly, you can make selections from different layers using the Select by Attribute tool. The process would be to use the Select by Attributes to make your first selection and once you get those results, go back into the Select by Attributes tool, change the Layer to the new layer you want to select from and change the Method to �??Add to current selection�?? (or one of the other options you may want to use, such as Remove from selected).

This allows you to have both of your query results displaying.
[ATTACH=CONFIG]14029[/ATTACH]

Is this what you were referring to?

ScreenShot110.png

michaelcollins1

JoshuaMcCurry

One option is to use the find dialog. If the field names are the same in all of the feature classes, you can find: a value In: <all layers> In field:Object_ID. Once you get your results, you can right click and select. Not sure if this is what you are looking for.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.