Exported Joined SDE Table Empty

Question

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

Bud · Answer

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

MeKohler · Answer

But why does the join work when the polygon layer is in a file geodatabase?

danretired · Answer

The fields should be of the same type and have matching contents for a join to persist