聚合函数中用iif判数语句，为什么不行？请 行家指教。
下面的语句是照抄张洪举权威指南书的命令。SELECT kx SUM(IIF(职称="助工",1,0)) AS 助工, ;SUM(IIF(职称="高工",1,0)) AS 高工, ;SUM(IIF(政治="团员",1,0)) AS 团员 ,;SUM(IIF(政治="党员",1,0)) AS 党员 from ab GROUP kx
提示：有不可识别的语句或关键字
附上表
ab.rar
(500 Bytes)
SELECT kx ,SUM(IIF(职称="助工",1,0)) AS 助工,SUM(IIF(职称="高工",1,0)) AS 高工,SUM(IIF(政治="团员",1,0)) AS 团员 ,SUM(IIF(政治="党员",1,0)) AS 党员 from ab GROUP by kx
