简单的sql语句，大家帮帮忙，急，在线等

[ballnan]

我想从Table2里查询一条记录然后插入表table1里面，我这样写有什么问题啊？？？
应该怎么改？？
insert into table1(a,b) values (select top1 a,b from table2)

[afdfgg]

insert into table1(a,b) select top1 a,b from table2

[mailxin]

insert into table1(a,b)
select top1 a,b from table2

[jxufewbt]

insert into table1(a,b) select top1 a,b from table2

[ballnan]

谢谢给位大哥了