Hi, I have a polygon layer in a SDE which I joined to a table in a different SDE. The join is successful but when I export the joined layer, the exported layer is empty. I then exported the polygon layer into a file geodatabase, joined it to the table and was able to successfully export the data. The export works when the data is in a file geodatabase but no when its in a SDE.
One thing that I should add is that the primary key in the polygon layer is a text field, while the primary key in the SDE table is Object Id.
Thanks,
Michael Kohler
The fields should be of the same type and have matching contents for a join to persist
But why does the join work when the polygon layer is in a file geodatabase?