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.
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!
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!