Exported Joined SDE Table Empty

[MeKohler]

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

[DanPatterson]

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

[MeKohler]

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