复制数据到另一个表

insert into RetiredUser (Id,UserName,Position)
select Id,UserName,Position
from User
where state ='Leave'