mysql表A中的user字段怎么更新，根据A、B、C三张表的关系？

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追问

加个限制条件，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

温馨提示：答案为网友推荐，仅供参考

当前网址：https://verywind.cn/ee/rxxvee3fvjyevev32y.html