>>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only