>>I must be making this harder than it is. I want to compare two databases >to each other. The records in database #A that are not contained in >database #B I want these records moved to a database #C. I will print this >as updated list and append the updated records to database #A. I have been >creating pure code and the project is going slow. The records however are >still coming in and not being updated. If anyone could offer an overview / >exact example that can be easier than pure code let me know.Thanks > >Let say that tables "A" and "B" have primary key 'Id'. Then following >statement will select records from A, non-contained in B, and put them in >newly created table C : >SELECT * From A Into Table C Where Id NOT IN (SELECT Id From B) > >Now you can REPORT FORM and then APPEND. in VFP 5.0 you can also do an outer join and not use a 3rd table Arnon