MySQL intersect 交集

for Oracle

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

forMySQL

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