UPDATE sgjle_member INNER JOIN sgjle_company ON sgjle_company.userid = sgjle_member.userid
SET sgjle_member.r_end = sgjle_company.r_end, sgjle_member.drop_vip = sgjle_company.drop_vip
WHERE sgjle_company.r_end > 1668578040 AND ( sgjle_company.r_end != sgjle_member.r_end ) AND ( sgjle_company.drop_vip != sgjle_member.drop_vip );
09-03
5323
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)