这个sql有问题吗

[cd_dragon]

accessRec.open "select id,name from table1",accessConn
sqlstr="insert into table2 (id,name) values("+accessRec("id")+","+ accessRec("name")+")"
oraConn.execute sqlstr

[BrentIvan]

select [id],[name] from table1

[BrentIvan]

="insert into table2 (id,name) values("+accessRec("id")+",'"+ accessRec("name")+"')"

如果id 是字符型，两边也加单引号

[wangchong]

select table1.id,table1.name from table1