1-5 練習

member_inof_view

select a.uid,a.name,a.uname,a.email,b.groupid,c.name as groupname,c.description,c.group_type
from xx_users as a join xx_groups_users_link as b on a.uid=b.uid
join xx_groups as c on b.groupid=c.groupid