求一SQL语句，在线等。。。。

[jzjrod]

我想把一个查询结果插入到表里怎么写？
insert into t_a values(select c_a,c_b from t_b order by c_a)
我这样写是错误，请问应该怎么写(两个表字段相同)

[gahade]

insert into t_a select c_a,c_b from t_b order by c_a

[jzjrod]

自己先顶一下

[fcuandy]

insert tb1 (fields list) select fields list from tb2

[mantti]

1. select c_a, c_b into t_a from t_b order by c_a

2. insert into t_a select c_a, c_b from t_b order by c_a

[jzjrod]

谢谢各位指导，已经搞定！