>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)
--sb--