SELECT inv_mas.inv_no, inv_mas.inv_date, inv_mas.amount, sum(rct_tran.amount) as ytdpaid ;
FROM aidata!inv_mas inner JOIN aidata!rct_tran ;
ON Inv_mas.inv_no = Rct_tran.inv_no ;
GROUP BY 1;
INTO DBF cInv

The above SQL command is perfectly working in VFP6. But when I tried it in VFP8 it gives me the following error message.

SQL: GROUP BY clause is missing or invalid.

Can anyone help me please?

Don