I'm using this code to make a join to a SQL Server database view.
arcpy.management.MakeQueryTable(CEView, "CE", "USE_KEY_FIELDS", "SID")
arcpy.management.JoinField(in_data=mem, in_field="id", join_table="CE", join_field="SID", fields=["SID", "ExpirationDate", "AnotherDate"])
Then I use CopyFeatures to write data back to the SQL Server but it gives me the output with "SID" but other fields "ExpirationDate", "AnotherDate" are not included in the output.
This process works if I use a table that includes the same data instead of a view. Is there any workaround for this?
