Add the distinct keyword to the command like this: APPEND swap2 TO soapcode WHERE spdesc NOT IN (SELECT DISTINCT spdesc FROM soapcode)
This forces the engine to create a separate list of spdesc values so in effect you are no longer comparing the table to itself when the append is done. Dennis McGrath ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of MDRD Sent: Friday, June 18, 2010 9:18 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Append using Varchar Hi I want to Append rows from 1 table to another where the data in a Varchar filed does not exist 95% of the data is already in the Target Table, and I only want to copy over the rows where that are missing. If I delete several rows from the target table or modify the data in the spdesc column on several rows I get 0 rows Appended. Is there a better way to do this? -- spdesc is a Varchar field APPEND swap2 TO soapcode WHERE spdesc NOT IN (SELECT spdesc FROM soapcode) Thanks Marc
