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附件有错误，我又找不到在什么地方！

where MAKTXX='氧化铝' as a

use mineBCA
go

select MAKTXX,count(CHEHAO) AS ch, Sum(MZQTY)-Sum(PZQTY) as sz, Sum(jZQTY) AS jz from zjlrestmp where Left(CZDAT,8)='20080723' and bfname= '经纬'and BWTAR=0 and pzflag=0 and MAKTXX='氧化铝'  group by MAKTXX

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