if you want query datas from one table and enter the output of the select query to another table can use query like this
"insert into table2 (ACCOUNTTYPE,ACCOUNTID) SELECT ACCOUNTTYPE,ACCOUNTID FROM table1" can use some where condition in select query part
This is working fine in mysql
Ramachandran