56,679
社区成员
发帖
与我相关
我的任务
分享
delete from score
where name not in (
select name1 from user
union
select name2 from user
union
select name3 from user);
.select *
from score as s left join (
select name1 from user
union
select name2 from user
union
select name3 from user) as u
on s.name=u.name1
where s.name is not null
.select *
from score
where name not in (
select name1 from user
union
select name2 from user
union
select name3 from user)
.