insert selected record into another table  with structure  without creating new table

insert into MyEmp * select user_id from Emp


insert selected record to already exist table


select user_id,pwd into Table2  from Table1