使用update语句即可：update crm_trader set code=a.code from l_trader as a where a.id=crm_trader.id;
update crm_trader set code=(select code from l_trader where l_rader.id=crm_trader.id)
