Thanks Dennis I think I will just start from scratch and make sure I don't have any typo's I never thought of Distinct
Marc From: Dennis McGrath Sent: Friday, June 18, 2010 9:37 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Append using Varchar 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
