I want to perform a APPEND FROM and here is my code:

use new_table
append from old_table

The problem is there is a fld in my new_table called new_value
and a fld in my old_table called old_value. I want the values in old_value to be inserted in the fld called new_value. What would the code look like to do something like this? thanks