注册 登录
编程论坛 Oracle论坛

各位老师,请帮我看看下面的代码有何问题。

leijinhe 发布于 2010-04-04 11:00, 644 次点击
语法没问题,就是调试时老出错,请各位诊断诊断。
Insert Into Errrb;
       Select a.Inriqi As Inriqi, Substr(b.Bjlx, 1, 2) As Bjlx, b.Xinghao As Xinghao, a.Ername As Ername, a.Ertype As Ertype, a.Quareason ,
                     a.Dutyren, Count(*) As Gzsl
        From Errdetail a
        Join Fisbase b On a.Ddid = b.Ddid And a.Wlid = b.Wlid
        Group By a.Inriqi, Substr(b.Bjlx, 1, 2), b.Xinghao, a.Ertype, a.Ername, a.Quareason, a.Dutyren
        Having Inriqi = To_Char(Sysdate() - 1, 'YYYY-MM-DD');
   

[ 本帖最后由 leijinhe 于 2010-4-4 11:51 编辑 ]
3 回复
#2
james2309322010-04-10 21:02
不懂.刚学习起步ing ..
#3
qxl85102010-04-15 15:09
主要提示的是什么错误呢???
#4
qxl85102010-04-15 15:09
感觉那个group那好像有点错误
1