给一个插入记录的例子?

我需要把一个表中数据插入到另一个表中?
[19 byte] By [mds2001w-苹果1号] at [2007-12-14]
# 1
Insert into table1 select * from table2;
commit;
qiuyang_wang-小数点 at 2007-10-22 > top of Msdn China Tech,其他数据库开发,SQL Anywhere Studio...