>I have an as400 file that holds my data. I use FoxPro as front end for my app. Some of the records in the data file were deleted. I have pulled the data file from a backup and found the missing records. How do I get the records from the back up to the production data file.

INSERT * INTO ProductionTable pt 
  SELECT * FROM BackupTable bt 
    WHERE not EXISTS (SELECT * FROM ProductionTable pt2 WHERE pt2.pk = bt.pk)