Question

VFP问题，SQL语言：Group by子句缺少或无效

SELECT Borr_retu.xh, COUNT(Borr_retu.xh), Reader.bj, Reader.xm;
FROM ;
tsgl_ku!reader ;
INNER JOIN tsgl_ku!borr_retu ;
ON Reader.xh = Borr_retu.xh;
WHERE ALLTRIM(STR(YEAR(Borr_retu.jsrq),4)) = '&nian';
AND ALLTRIM(STR(MONTH(Borr_retu.jsrq))) = '&yue';
GROUP BY Borr_retu.xh;
ORDER BY 2 DESC;
INTO CURSOR paihangbang

这是一个查询，运行之后就跳出来“Group by子句缺少或无效”的提示。弄了几个小时，也不知错在哪里，恳请大神指教！

Answer 1

SELECT Borr_retu.xh, COUNT(Borr_retu.xh), Reader.bj, Reader.xm;
FROM ;
tsgl_ku!reader ;
INNER JOIN tsgl_ku!borr_retu ;
ON Reader.xh = Borr_retu.xh;
WHERE ALLTRIM(STR(YEAR(Borr_retu.jsrq),4)) = '&nian';
AND ALLTRIM(STR(MONTH(Borr_retu.jsrq))) = '&yue';
GROUP BY Borr_retu.xh,Reader.bj, Reader.xm;
ORDER BY 2 DESC;
INTO CURSOR paihangbang

Answer 2

在运行这个查询语句之前 先
SET ENGINEBEHAVIOR 70

应该就可以了