SELECT A.ID, B.ID
FROM A
EXCEPT
SELECT A.ID, B.ID
FROM B;
SELECT A.ID, B.ID
FROM A
WHERE NOT EXISTS (
SELECT 'X'
FROM B
WHERE A.ID = B.ID AND B.ID = A.ID
);
SELECT X.ID, Y.ID
FROM (
SELECT ID
FROM A
INTERSECT
SELECT ID
FROM B) X, Y
WHERE X.ID = Y.ID;
SELECT X.ID, Y.ID
FROM A
WHERE NOT EXISTS (
SELECT 1
FROM B (
SELECT ID
FROM A
MINUS
SELECT ID
FROM B) Y
WHERE X.ID = Y.ID;
SELECT A.ID, B.ID
FROM A LEFT OUTER JOIN B ON A.ID = B.ID
UNION
SELECT A.ID, B.ID
FROM A RIGHT OUTER JOIN B ON A.ID = B.ID;
SELECT A.ID, B.ID
FROM A LEFT OUTER JOIN B ON A.ID = B.ID
UNION ALL
SELECT A.ID, B.ID
FROM A RIGHT OUTER JOIN B ON A.ID = B.ID;