常用SQL

update select联合语句

update T_YW_CKItemstock
set itemname=t2.itemname,size=t2.size,unitname=t2.unitname
from T_YW_CKItemInfo t2,T_YW_CKItemstock t1
where t1.itemnum=t2.itemnum