34,575
社区成员
发帖
与我相关
我的任务
分享
update a
set a.money_left=a.money_left-b.cons_money
from a left join b
on a.meal_card_code =b.meal_card_code
update a
set a.money_left = a.money_left - b.cons_money
from a inner join b
on a.meal_card_code = b.meal_card_code
update a set a.money_left = a.money_left - b.cons_money from a inner join b on a.meal_card_code = b.meal_card_code
update
a
set
a.money_left=a.money_left-b.cons_money
from
a,b
where
a.meal_card_code =b.meal_card_code
UPDATE A
SET A.money_left=A.money_left-B.cons_money
FROM A INNER JOIN B ON A.meal_card_code = B.meal_card_code