MySQL EXISTS

https://yahwang.github.io/posts/35

MySQL에서 연관 서브쿼리 연산자 EXISTS 활용하기 - YA-Hwang 기술 블로그

select * from clans where exists (select * from clan_members where clans.clan_master_id = clan_member_id and clan_members.role = 1);