Can anyone suggest why I 'd be getting the following error in the
following SQL Statement (VFP 8.0)
Error: SQL: Group by clause is missing or invalid.
SELECT INVDTE , ;
INVNO, ;
gLASST, ;
ARSTAT,;
IIF(ARSTAT = "V",(0* extweight),SUM(extweight)) AS ntotweight;
FROM (gcarpath + "ARTRAN" + gcCompID) ;
HAVING BETWEEN(INVDTE,dBeginDate,dEndDate) ;
INTO DBF (gcdatpath + 'tmpdata') ;
GROUP BY INVDTE, INVNO, gLASST ;
ORDER BY INVDTE, INVNO, gLASST
Thanks,
Philip
©2004 PLB |
