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?
What version of Pro and what kind of database? For example, Oracle 18c 10.7.1 enterprise geodatabase.
If you cast one of the join fields in a query layer or database view, so that the datatypes are the same, do you still see this issue?
SQL:
SELECT
CAST(MY_TEXT_FIELD AS INT) AS MY_TEXT_FIELD,
T.*
FROM
MY_TABLE T