mysql 关系表查询_Mysql查询关系M-M表

I'm having a small problem making a query in MySQL.

I have the following tables:

member;

group;

member_has_group (this one has the columns id_group referes to the group id and id_member referes to member id)

I'm trying to make a query that gives me the members from a selected group. Can you help me?

I'm not familiar with join tables, but for the search i made i think thats probably one of the solutions.

Thanks in advance.

Elkas

解决方案

If you know the group id

select member.* from member m

inner join member_has_group mg on m.id = mg.id_member

where mg.id_group = [x]

If you only know the group name

select member.* from member m

inner join member_has_group mg on m.id = mg.id_member

inner join group g on g.id = mg.id_group

where g.name = 'group name'