Re: optimal sql

Christoph Seidel wrote:

> how can i find all records by pk in table 1 which are not in table 2

I usually use something like:

SELECT
  t1.key1,
  t1.key2
FROM table1 t1
MINUS
SELECT
  t2.key1,
  t2.key2
FROM table1 t2

--
Billy