mysql从一张表更新另一张表

Question

我尝试下面的代码不起作用我 guest 也许where子句不正确

 update member set member.`status` = 4
     where member.idmember = select DISTINCT activitynote.idmemberref where activitynote.checkkey =4

然后我尝试

update member, activitynote set member.`status` = 4
 where member.idmember = activitynote.idmemberref
and activitynote.checkkey = 4

这段代码可以工作，但不是我想要的，请帮忙

member.idmember为主键，activitynote.idmemberref可以重复

Answer 1

如果我理解正确，那么应该可以解决问题。

update member set member.`status` = 4
where member.idmember IN 
(select DISTINCT activitynote.idmemberref from activitynote where activitynote.checkkey =4)