begin transaction

insert into mt.vallinkdata("root", rootdata, data1, data2)

select '4247', (trim(First_Name) + ' ' + trim(Last_Name)), trim("merge"), trim(Email_Address) from mt.mrg4202;

commit transaction;