原创

update

update yx_整合人员0331 a set a.status = (select 确认结果 from yx_user_qy_确认0331 b where a.用户id = b.用户id)
where exists (select 1 from yx_user_qy_确认0331 c where a.用户id = c.用户id)

正文到此结束
本文目录