Are there any other ways to pull rows where a unique key is on a row in table A , but not in a row in table B? Here is how I know how to do it, but am wondering if there are any other ways. Thanks in advance!
-- Way 1 SELECT * FROM TABLE_A A WHERE NOT EXISTS ( SELECT NULL FROM TABLE_B B WHERE A.KEY = B.KEY )
SELECT * FROM TABLE_A A LEFT JOIN TABLE_B B ON A.KEY = B.KEY WHERE B.KEY IS NULL
In table A, not in table B
Posted - 08/21/2006 : 15:47:27
