Update A Set 已结算=B.已结算+本次结算,未结算=B.余额 from TableName1 A Inner Join TableName2 B On A.单号=B.单号OrUpdate A Set 已结算=B.已结算+本次结算,未结算=B.余额 from TableName1 A ,TableName2 B Where A.单号=B.单号
Update A Set 已结算=B.已结算+本次结算,未结算=B.余额 from TableName1 A Inner Join TableName2 B On A.单号=B.单号OrUpdate A Set 已结算=B.已结算+本次结算,未结算=B.余额 from TableName1 A ,TableName2 B Where A.单号=B.单号
from table1, (select 单号, Sum(已结算) as 已结算, Sum(余额) as 余额 from table2 加查询条件,group by 单号) as table2
where table1.单号 = table2.单号