topic Re: Create Database View on Desktop in ArcGIS Enterprise Questions

Create Database View on Desktop

EmilyL — Thu, 24 May 2018 16:39:38 GMT

Hello GeoNet,

I am trying to create a Database View that have a simple join from one layer with spatial information with another table in SDE. l am not sure what I am missing here.

For example:

layer1 is the spatial layer

layer2 is the table layer

I'd like to join them with the 'joinID' field from layer1 and the 'PROJECT_ID' field from layer2.

This is the error message I've received:

Any pointers are greatly appreciated please.

Thanks a lot!

Re: Create Database View on Desktop

Anonymous User — Thu, 07 Jun 2018 14:22:25 GMT

I believe the formatting is off -- try the sample below:

SELECT * FROM layer1 LEFT INNER JOIN ON layer1.joinID = layer2.PROJECT_ID

Re: Create Database View on Desktop

EmilyL — Fri, 29 Jun 2018 16:56:50 GMT

Thank you very much for your help, Andrew! It's run successfully this time, but I couldn't find where the output layer. It should be the same location as the input location, right? I've checked the Workspace location under the Environment Setting, and it should be the same as the input location. Where else should I check please? Thanks again!