各位老师，请帮我看看下面的代码有何问题。
语法没问题，就是调试时老出错，请各位诊断诊断。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 编辑 ]
