If you can't beat 'em, 'em!

Table ATable B
SELECT * FROM A LEFT INNER JOIN B ON A.value = B.value;SELECT * FROM A LEFT INNER JOIN B ON A.value = B.value WHERE B IS NULL;
-- or
SELECT * FROM A LEFT OUTER JOIN B ON A.value = B.value;SELECT * FROM A FULL OUTER JOIN B ON A.value = B.value;SELECT * FROM A RIGHT INNER JOIN B ON A.value = B.value;SELECT * FROM A RIGHT INNER JOIN B ON A.value = B.value WHERE A.value IS NULL;
-- or
SELECT * FROM A RIGHT OUTER JOIN B ON A.value = B.value;SELECT * FROM A FULL OUTER JOIN B ON A.value = B.value WHERE A.value IS NULL OR B.value IS NULL;SELECT * FROM A INNER JOIN B ON A.value = B.value;
Built by Benjamin Oertel