MySQL에서 MINUS 구현

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