可以这么加:
insert into 第二个表
select col1,col2,sum(col3)
from 第一个表
group by col1,col2[/quote]
哦哦 谢谢 我试验下 [/quote]
‘
显示在关键字 'from' 附近有语法错误。
我的语句是 insert into ljsj select a1,sum(cast(a2 as float) from cs1 group by a1[/quote]
少了一个括号:
insert into ljsj select a1,sum(cast(a2 as float)) from cs1 group by a1[/quote]
额 谢谢了。。
可以这么加:
insert into 第二个表
select col1,col2,sum(col3)
from 第一个表
group by col1,col2[/quote]
哦哦 谢谢 我试验下 [/quote]
‘
显示在关键字 'from' 附近有语法错误。
我的语句是 insert into ljsj select a1,sum(cast(a2 as float) from cs1 group by a1[/quote]
少了一个括号:
insert into ljsj select a1,sum(cast(a2 as float)) from cs1 group by a1
可以这么加:
insert into 第二个表
select col1,col2,sum(col3)
from 第一个表
group by col1,col2[/quote]
哦哦 谢谢 我试验下 [/quote]
‘
显示在关键字 'from' 附近有语法错误。
我的语句是 insert into ljsj select a1,sum(cast(a2 as float) from cs1 group by a1