Join from standalone table to FC — Bring in FC's shape field

Bud

If I create a join from a standalone table to a feature class, then I want the FC's shape field to be included in the list of joined fields in the attribute table.

I'm aware that I can do something similar with an EGDB query layer or database view via SQL. But it would be best if I could do it in an OOTB join too -- for simplicity, ease of creation, and for parts of the ArcGIS platform that don't support SQL joins.

The resulting Contents item would be a spatial feature layer, not a standalone table view.

I'm aware that we can't bring in the joined shape when joining from an FC to an FC, since that would result in two shape fields in the same attribute table, which would destabilize ArcGIS Pro. See @DrewFlater's comment here.
However, the standalone table to FC scenario is different, because there would only be one shape field in the resulting attribute table.

TanuHoque

@Bud 

It should work unless I misunderstood what you asked for 😞

If I have a FC and a table in my database and I want to join them, I'd do this:

• add the FC in a map as a feature layer
• (optionally) add the table to the map
• select the feature layer
• use the Join option from the ribbon tab (i believe inside the Data group tab) to bring up Add Join gp tool
• select the standalone table (or browse to the db to pick the table)
• set primary and foreign keys
• click OK

It creates the join between the layer and standalone table --> basically brings all attributes from the table to the feature layer.

please let me know if I misunderstood.