Using arcpy, I have created a database connection (sde). I'm trying to join tables from the sde and export the results to a table within a geodatabase, however, whether via a table view or copying the tables to join (copy, table to table, table to geodatabase, copy rows, RecordSet), the join fails because the unique identifier data is overwritten by a numerically sequential OBJECTID. How can I maintain the actual data within the unique identifier field rather than have it be overwritten by the numerical sequence of OBJECTID?
