use mineBCA
go
SELECT a.MAKTXX as maktxx, Count(a.CHEHAO) AS ch, Sum(a.MZQTY)-Sum(a.PZQTY) as sz, Sum(a.jZQTY) AS jz from (select * from zjlrestmp where Left(CZDAT,8)='20080723' and bfname= '经纬'and BWTAR=0 and pzflag=0 ) as g where MAKTXX='氧化铝' as a group by a.maktxx

在查询分析器中为什么老显示在AS附件有错误，我又找不到在什么地方！

谢谢各位
我整天已经调试出来了 答案和xinzheng一样