Hi

I am trying to transfer an SQL statement from a FPD26 program into VFP9, but the command doesnt seem to work

Select customer.name, customer.code, COUNT(*), SUM(ord_tot - vat) AS value,
SUM(IIF(orders.o_type $ 'ABCDPS', 1, 0)) AS paid, SUM(IIF(orders.o_type
 $ 'ABCDPS', 0, 1)) AS unpaid, SUM(orders.adw) AS s_adw, SUM(carriage) AS s_carr, SUM(vat) AS s_vat FROM ORDERS,CUSTOMER WHERE orders.ent_date<
 (entdate) AND BETWEEN(orders.fun_date, (f_start), (f_end)) AND customer.code = orders.customer AND customer.custgroup = what INTO CURSOR T1

Creates one record into FPD26, with all the totals I need, but in VFP9 I get group by clause is missing or invalid.

Any help extremley appreciated