SELECT 'missing in b', a.* FROM a LEFT OUTER JOIN b ON a.key1 = b.key1, a.key2 = b.key2 WHERE b.key1 IS NULL AND b.key2 IS NULL