Marc - One difference between the APPEND command and the INSERT command is that using the APPEND command you can reference the target table in the WHERE clause.
So your APPEND statement could look something like this: APPEND Table2 TO Table1 + WHERE PrimaryKeyColumnInTable2 NOT IN (SELECT PrimaryKeyColumn FROM Table1) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Sami Aaron Software Management Specialists 913-915-1971 [EMAIL PROTECTED] > > -----Original Message----- > > From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Marc > > Sent: Wednesday, June 29, 2005 8:39 AM > > To: RBG7-L Mailing List > > Subject: [RBG7-L] - Insert > > > > Hi > > > > I want to insert several hundred rows of data into > > a table for my users. The problem is some of them > > already have some of these rows of data and when > > the insert command tries to add a row that already > > exists I get an error and the process stops. > > > > *there is a unique rule on the main column > > > > So, is there a better way to "insert" these rows > > into their table and have it ignore the duplicate > > rows but keep processing the rest of the rows > > of data? > > > > Thanks > > Marc > > > > > >
