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; } } }

Query layer to show two tables as one

dougbrowning

I am trying to make a query layer that shows two tables in one. Both tables have the exact same schema. It is not a join, just want to show the two tables like they are one to the user. They are in the same SDE.

In SQL I can just do this

SELECT * FROM [ilPub].[PubDBO].[TERRA], [ilPub].[PubDBO].[LMF]

In ArcMap I get a ambiguous name objectid error. I have done a ton of searching but only finding joins.

thanks

Encuentra más publicaciones etiquetadas con

Content Management

Accepted answers

ABishop

If you want to write a SQL statement to accomplish this without appending the tables, you can use a UNION

https://mode.com/sql-tutorial/sql-union/

All comments

dougbrowning

Just straight union if the schemas are the same, and they must be. If not add a field list to make them the same. Also it must have a ObjectID field. If versioned make sure to use the views.

select * from Pub.PubDBO.Terr_evw UNION ALL select * from Pub.PubDBO.LMF_evw

hope that helps

MapsAreFun

Hi, just wondering if you can post an example of the union sql you used for this query layer? I have tried the options provide on https://mode.com/sql-tutorial/sql-union/ but I am receiving a "Operation failed" message in ArcGIS Pro.

ABishop

You're welcome

dougbrowning

Ok it looks like that worked. thanks a lot

ABishop

If you want to write a SQL statement to accomplish this without appending the tables, you can use a UNION

https://mode.com/sql-tutorial/sql-union/

ABishop

Do you want them to be permanently this way? If so, you always append one table to the other.

dougbrowning

They are not to be joined or related. I just want to see both at once in the same table. So if I have 1,000 records in table 1 and 500 in table 2 then the result table has 1,500 rows.

Thanks

ABishop

In order to do this you must have a unique ID that you can either join or relate the tables.

dougbrowning

The two are not related. Just want to show both.

Table 1

Table 2

Final table

Thanks

ABishop

Hello @DougBrowning

Try a relate.

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

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