Знатоки фокса, помогите, выскакивает ошибка синтаксиса,
подключаюсь из клиента через Provider=vfpoledb.9
SELECT DateDoc, COUNT(IDDOC) AS Que_Розн, SUM(Sum1) AS SumPlus_Розн, SUM(Sum2) AS SumMinus_Розн
FROM
(
SELECT journ.DATE AS DateDoc,
journ.IDDOC,Doc.SP7998,
IIF (Doc.SP7998 = 0,SUM(Tab.SP8009),00000000000.00) As Sum1,
IIF (Doc.SP7998 = 1,SUM(Tab.SP8009),00000000000.00) As Sum2
FROM 1SJOURN AS journ
INNER JOIN DT8012 AS Tab ON journ.IDDOC = Tab.IDDOC
INNER JOIN DH8012 AS Doc ON Doc.IDDOC = Tab.IDDOC

WHERE (journ.IDDOCDEF LIKE '%66K%')
AND (journ.DATE >= {^2005-04-01}) AND
(journ.DATE < {^2005-05-01})
AND (journ.CLOSED AND 1 = 1)
GROUP BY journ.DATE,journ.IDDOC,Doc.SP7998
)
GROUP BY DateDoc
ORDER BY DateDoc