Dear Experts...
I just upgraded to VFP 9.0, where the syntax for the GROUP BY clause has changed and requires to list all the fields. I am new to su-queries.
I want to select multiple fields from a table but SUM & GROUP BY by field (itm_nuymb) only. Can someone give me a proper syntax to accomplish that. Listed below is a sample code which I think need a sub-query and I am new to that.

             SELECT itm_numb, itm_desc, sls_code, tax_code, SUM(unt_qtty) AS nQty ;
    	FROM table1  GROUP BY itm_numb ORDER BY itm_numb

Thank you in advance.

Raza Malik