SQL语句 怎么把从一个表中查出来数据插入到另一个表中

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