请各位高手帮我改改这个很奇怪的SQL语句,在线等

[njuzgj]

目的是从一个表中处理的数据插入到一个新的表中，可老是提示"缺少VALUES"关键字,请高手诊断一下,

insert
into hndl.T_KH_HZS(KHZF,BKHBH,BKHXM,KHTYPE,KHYEAR)
as
select * from

(

select sum(aa)ssum,bkhrgh,bkhrxm,khjd,khnd from (
select sum(khfz)/count(*)*0.3 as aa,bkhrgh,bkhrxm,khrlb,khjd,khnd from hndl.rz_t_jxkh_rykh where khrlb='同级考评' group by bkhrgh,bkhrxm,khrlb,khjd,khnd
union all
select sum(khfz)/count(*)*0.3 as aa,bkhrgh,bkhrxm,khrlb,khjd,khnd from hndl.rz_t_jxkh_rykh where khrlb='下级考评' group by bkhrgh,bkhrxm,khrlb,khjd,khnd
union all
select sum(khfz)/count(*)*0.4 as aa,bkhrgh,bkhrxm,khrlb,khjd,khnd from hndl.rz_t_jxkh_rykh where khrlb='上级考评' group by bkhrgh,bkhrxm,khrlb,khjd,khnd
)bb group by khnd,bkhrgh,bkhrxm,khjd)cc

[qiaozhiwei]

把 AS 拿掉试试

[超叔csdn]

把AS去掉

[zzwind5]

把 AS 去掉

[njuzgj]

呵呵，把AS拿掉后可以了，可插不进数值,我要精神分裂了，郁闷啊

[njuzgj]

客户真变态,

[超叔csdn]

是你检索没值还是类型有差别?
自己检查一下吧

[qiaozhiwei]

你在什么地方执行啊，记得要commit啊

[moonfkypm]

莫名