Hello to All!

I used GROUP BY command in an SQL statement to SUM UP a certain information:

SELECT b.empno, b.start, b.end,;
SUM(b.regpay) AS vregpay, SUM(b.otpay) AS votpay;
FROM Paysumm b WHERE b.period2=CTOD('02/15/2004') GROUP BY b.empno

The code above works perfectly on VFP 6 and 7. However, when I tried executing it on VFP 8, it gave a "SQL: Group By Clause is missing or invalid" error!?

Can you help me on this? Thanks!