Re: Avoiding Duplicate Inserts

You can either do a lookup using some kind of outer join or simply subtract the data you want to insert in the table from the data already present in the table using 'MINUS':

select key
from target
minus
select key
from source

sim Received on Mon Nov 21 2005 - 02:33:34 CST