insert into T_annual(year,userid,username) select hryear,userid,username from T_annualleavebase where ...