SELECT users.mail, users.name FROM members
LEFT JOIN users ON (users.uid = members.uid) WHERE members.group = 27
AND members.uid NOT IN (SELECT subgroup_members.uid FROM subgroup_members
LEFT JOIN subgroups ON (subgroups.id = subgroup_members.sid)
LEFT JOIN users on (users.uid = subgroup_members.uid) WHERE subgroups.oid = 27 AND subgroup_members.leader = 1)
此查询返回不是子组的领导者的组的所有成员.
members表显示哪个userid(uid)属于一个组(group),subgroup_members表显示哪些用户属于一个子组(sid).领导在subgroup_members表的leader列中用’1’表示.
我试图找出如何返回一个不是一个子组的唯一领导者的组的所有成员,我现在很难过.
因此,我需要确定它是否是唯一的值,而不是subgroup_members.leader = 1