1 update A set A.name='xxx',
age= case when B.age=0 then 2 2 when B.birthday>'2018-01-02' then 1 end 3 from tt
1 update A set A.name='xxx',
age= case when B.age=0 then 2 2 when B.birthday>'2018-01-02' then 1 end 3 from tt
转载于:https://www.cnblogs.com/ZkbFighting/p/10270513.html