mysql的except_MySQL中的EXCEPT ALL等效项

So I have a table called members and another table called group.The leader of the group is also a member

To retrieve members,who are not leaders I did the following

code:

SELECT first_name, last_name, rank

FROM members

EXCEPT ALL

SELECT first_name, last_name, rank

FROM members INNER JOIN groups ON mid=leader; --edited gid as mid

Doing this in MySQL gives me a syntax error.What should I use for EXCEPT ALL in MySQL?

解决方案SELECT first_name, last_name, rank

FROM members

LEFT OUTER JOIN groups ON gid=leader

WHERE leader is null

Not sure if leader or gid is in the groups table. The column that is in the groups table must have a null check in the where clause.