select ilMCU,GLEXR,GLEXA,GLANI,GLDCT,GLDOC,GLDGJ,sum(GLAA),SUM(ILPAID) from crpdta.f0911 left join crpdta.f4111 on GLKCO=ILKCO and GLDOC=ILDOC WHERE LTRIM(RTRIM(GLANI)) = '10.1403.01' AND GLSUB='01' and ILDCT<>'IT' and ILDCT<>'RI' and gLDCT<>'IT' and gLDCT<>'RI' group by ILMCU,GLEXR,GLEXA,GLANI,GLDCT,GLDOC,GLDGJ,GLAA having sum(ILPAID)<>sum(GLAA) 注意修改红色字体部分
|Archiver|小黑屋|手机版|壹佰网 ERP100
( 京ICP备19053597号-2 )
IP卡
狗仔卡
发表于 2008/12/7 20:01:53
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
抢沙发
千斤顶
显身卡