如何根据MySQL中第三个表中的id将数据从一个表复制到另一个表？

Question

I have three tables like

Table1

It's a blank table that have same columns as Table2.

Table2

It contains the actual data that needs to be copied in Table1.

id   cola   colb   colc cold
1     hd     dj    dj    dh
2     hf     uy    ug    se
...

Table3

Before copying data from Table2 to Table1, first I need to verify that if the id is present in Table3 or not. In other words I just want to copy the rows from Table2 to Table1 whose id exist in Table3.

id   col1    col2
1     xy      zz
2     ys      sh

One more thing Table2 & Table3 contains half millions of rows, so query must be feasible.

Answer 1

Option 1 using subquery:

insert into Table1 
select * from Table2 where id in (select id from Table3)

Option 2 using INNER JOIN:

insert into Table1 
select * from Table2 INNER JOIN Table3 USING(id);