INTERSECT

use OF INTERSECT -  returns ONLY the ROWS FOUND by BOTH queries
SELECT NAME   FROM customers INTERSECT   SELECT NAME FROM friends