Copy record where there are additonal fields.

[swalters]

Is there a fast and clean way to copy a row from one table to another where the destination table has additional fields.

Eg,

src_table.
KEY, BLAH, BLAH2

dest_table
archive_date, archive_reason, KEY, BLAH, BLAH2

Thanks.