I need to auto populate field data in one table using the reference of other table. I tried this using some sql scripting in arcpy. using the script I was able to pull the data from table but not modifying of the data.
# Use a connection file to create the connection
egdb = r'C:\Users\mlgsadmin\AppData\Roaming\ESRI\Desktop10.6\ArcCatalog\Connection to 10.72.15.186.sde'
egdb_conn = arcpy.ArcSDESQLExecute(egdb)
table_name = 'SDE.BPPL_Overall_Status'
field_name = 'Status'
sql = '''
SET BPPL_Overall_Status.Clearing = Cleraing_ROW_0_175_Km.STATUS
Inner Join Cleraing_ROW_0_175_Km
egdb_return = egdb_conn.execute(sql)
This was the script used.