t1
-----------------------
id A B Ct2
---------------------
id F如果满足条件:t1.id = t2.id , t1.B = '0', F = null
就把F的值设置为C
请问如何实现 ?
-----------------------
id A B Ct2
---------------------
id F如果满足条件:t1.id = t2.id , t1.B = '0', F = null
就把F的值设置为C
请问如何实现 ?
set b.f =
(select a.c from t1 a
where a.id = b.id and b.b<>0 and a.f is null
)