How to move fields from one table to another?

Question

SQL

I have 2 tables.
First with
ID_fnd and idteh fields
152 A
333 B
111 C
Second:
ID_fnd and Name
152 I1
333 I2
111 I3
How do I move the idteh field to another table so that I can search it SELECT * FROM table2 WHERE idteh='A'

Answer 1

insert into dbo.table_2 (Name_2)
select
 Name_1
from dbo.table_1