update a set a.shuliang=a.shuangliang-b.shuliang from a join b on a.plu=b.plu
update a set a.shuliang=a.shuangliang-b.shuliang from a inner join b on a.plu=b.plu
update a set shuliang=a.shuangliang-b.shuliangfrom ajoin b on a.plu=b.plu
--可查,可改.;with t as( select a.*,a.shuangliang-b.shuliang as shuliangNew from a inner join b on a.plu=b.plu )--select * from t; update t set shuliang=shuliangNew;
update a set a.shuliang=a.shuangliang-b.shuliang
from a
join b on a.plu=b.plu
update a set a.shuliang=a.shuangliang-b.shuliang
from a
inner join b on a.plu=b.plu
update a set shuliang=a.shuangliang-b.shuliangfrom ajoin b on a.plu=b.plu
select a.*,a.shuangliang-b.shuliang as shuliangNew
from a
inner join b on a.plu=b.plu
)--select * from t;
update t set shuliang=shuliangNew;