根据表中的一个字段查找另外一个表的ID更新到这个表的字段上

update CT_KMY_ZhKmAndJxxtKmRelation t1 set (CFJxxtKmID) =
(
select t2.fid from T_BD_AccountView t2 where t2.fnumber=t1.CFJxxtKmNumber and t2.fcompanyid='MwAAAAAAAATM567U'
)




select fid,fnumber  from T_BD_AccountView t2 where t2.fcompanyid='MwAAAAAAAATM567U' and fnumber = '1601.04'


select CFJxxtKmID,CFJxxtKmNumber  from CT_KMY_ZhKmAndJxxtKmRelation where CFJxxtKmID is null