高手帮忙 sql语句

hbutwzc 发布于 2008-07-29 09:47， 1080 次点击

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

3 回复

makebest2008-07-29 10:57

where MAKTXX='氧化铝' as a

xinzheng2008-07-29 15:51

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

hbutwzc2008-07-30 11:13

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