SQL INNER JOIN

#三表联合查询,查询下列人员的角色
select a.id,a.name,a.user_name_of_7moor,s.display_name
from kpl_prd.admin_members a inner join kpl_prd.admin_member_role r on a.id = r.admin_member_id
    inner join kpl_prd.roles s on s.id = r.role_id
where a.name in (
'夕',
'华',
'斌',
'苗',
'鄂',
'生',
'怡',
'昊',
'蓉',
 '丰',
'铭'
)