復(fù)制代碼 代碼如下:

SELECT member_id, name FROM a
INTERSECT
SELECT member_id, name FROM b

復(fù)制代碼 代碼如下:

SELECT a.member_id, a.name
FROM a INNER JOIN b
USING (member_id, name)

復(fù)制代碼 代碼如下:

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

復(fù)制代碼 代碼如下:

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

復(fù)制代碼 代碼如下:

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