column numbers and type must match in inserted table from the select 
 

 insert into Members (number, name)
   select number, name from NewMembers

Reply via email to