Select Report.Model,
Sum(case when Detail.WorkCode=1 then Detail.WorkCode else 0 end) WorkCode1,
Sum(case when Detail.WorkCode=2 then Detail.WorkCode else 0 end) WorkCode2,......From ProdReport Report,ReportDetail Detail
Where Report.ID=Detail.ProdReportID
Sum(case when Detail.WorkCode=1 then Detail.WorkCode else 0 end) WorkCode1,
Sum(case when Detail.WorkCode=2 then Detail.WorkCode else 0 end) WorkCode2,......From ProdReport Report,ReportDetail Detail
Where Report.ID=Detail.ProdReportID
能不能给解释一下为什么不能用IIF?
我看帮助里也有IIF这个函数的啊?
马上给分!!
所以,在 sql 查询分析器中,无法识别该语句。