How to insert data from one table to another?

Help with sql statement - insert data into two table?

• I am new to sql .please help me with this . the following sql statement works only on one table "insert into table1(id,name,ref,amount) select id,name,ref,amount from table where name = A" How do i use it to insert into multiple tables like this "insert into table2 (id,name,ref,amount) select id,name,ref,amount from table where name = B" "insert into table3 (id,name,ref,amount) select id,name,ref,amount from table where name = C"

• Answer:

  multiple statements. There is no way to do it in one statement how you have it