MySQL MINUS 差集

for Oracle

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

for MySQL

SELECT PHONE
FROM PHONE_a LEFT JOIN PHONE_b on PHONE_a.PHONE = PHONE_b.PHONE
WHERE PHONE_b.PHONE IS NULL