如题所述
![](https://bktvggkkd4nm2ppn5jmx.cdn.bcebos.com/mda-kjvp5q53e2gvg2de/mda-kjvp5q53e2gvg2de.jpg?x-bce-process=image/resize,m_lfit,w_450,h_600,limit_1/quality,q_85)
update A set A.user=C.user from A
inner join B on B.code=A.code
inner join C on C.circle=B.circle and c.month=B.month追问
inner join B on B.code=A.code
inner join C on C.circle=B.circle and c.month=B.month追问
加个限制条件,A.code大于3的
追答update A set A.user=C.user from A
inner join B on B.code=A.code
inner join C on C.circle=B.circle and c.month=B.month
where A.code>3
温馨提示:答案为网友推荐,仅供参考