Re: Create a single-record append query without warnings on duplicates

Greetings,

Here is a sample for inserting records into a table that don't already
exist in that table using the "Not Exists" clause - this will prevent
inserting duplicate records:

Insert into tbl2 Select t1.* from tbl1 t1 Where Not exists (Select *
from tbl2 t2 Where t2.ID = t1.ID)


Rich

*** Sent via Developersdex http://www.developersdex.com ***
.