update a set col1=b.col2 from a,b where a.sfz=b.sfz;
update a set a.col1 in (select b.col2 from b where a.sfz=b.sfz) 应该是这样的不吧!
