Assuming you have two tables A and B and both are having columns x and y.
Now you want to insert data of table A into table B (value of x column of A table into x column of B table and so forth)
The query would be -
insert into B (x,y) select x,y form A
You can write the query in above format. The above query is a single query do not mistake it for two different queries.