两个表之间数据更新

update? bmp_client t? set?? t.firmcode=(
select? c.licensecode
????????? from clt_clt_info@biz_dblink.regress.rdbms.dev.us.oracle.com c? where?? t.client_no=c.cltno

)