Create a layer from a table and a layer using a Join

[lmotta_ibama]

Hi guys,

I would like create  a layer, from a table , where the geometry field (Shape) come from a layer using a Join.

My table have a key, where can use with a layer with same field (key).

The 'Add Join' tool, get all field from layer, but, not add the geometry.

Have a tool in ArcGIS Pro for add the geometry in a table, to create a layer ?

Or

I can use a SQL and the result i define how a layer ?

I have a lot of tables, and I need the geometries from a only layer.

A SQL can be this:

SELECT t.id_city, t.name_seller, t.total, l.Shape

FROM cities_salles t

INNER JOIN cities l ON t.id_city = l.id

[RhettZufelt]

Where is your geometry?  In a table, feature class?

Basically, make/copy your feature class with the geometries, then use Join Field to add table to that copy of the feature class.

R_

[lmotta_ibama]

Thanks RhettZufelt ,

I have a layer (feature class), that i would like use yours geometries to others tables.

All tables have a key, that join with the key of layer.

The "Join field" tool, add only attributes from the foreign table.  This case, it add all attributes of all tables. The result a layer with a lot of attributes.

I would like use the geometries from the only a layer for all tables, then, I can work with each table with geometries from the same layer.

The idea is have a "Join Geometry" tool, then, we can do a Join from the fields (table and layer), that the geometries of layer will be add in table, promoting a table to layer.