How about using this command.

example:
use table1
use table2
append from table1

By the way I forgot to mention that you need to supply the for clause in order for you to filter to the current record.

example: append from table1 for Field = <>