abcbb(提问者)select TargetProduction- sum(OKQuantity+NGQuantity) as 未完成,
sum(OKQuantity+NGQuantity) as 已完成
from TB_BulletinBoardItemInfo
where ProductionCode=\'B14\'
GROUP BY TargetProduction;
sql server的库 怎么处理下呢
abcbb(提问者) 回复 snrtuemcselect * from (select TargetProduction- sum(OKQuantity+NGQuantity) as 未完成,
sum(OKQuantity+NGQuantity) as 已完成
from TB_BulletinBoardItemInfo
where ProductionCode=\'B14\'
GROUP BY TargetProduction) where TargetProduction- sum(OKQuantity+NGQuantity) as 未完成>0
关键字 \'where\' 附近有语法错误。