Re: How to use minus in mysql

[Megan Mercy]

To transform the statement

SELECT member_id, name FROM a
MINUS
SELECT member_id, name FROM b

The easy-to-understand transformation is:

SELECT DISTINCT member_id, name
FROM a
WHERE (member_id, name) NOT IN
(SELECT member_id, name FROM table2);


SELECT DISTINCT a.member_id, a.name
FROM a LEFT JOIN b USING (member_id, name)
WHERE b.member_id IS NULL

http://www.etaxportal.com/