Hi friends:
This is what I always wanted to do but I've never got it.
Anyone can tell me what is the correct way for "grouping by" in a SELECT SQL command?
I tried FROM field table, INTO CURSOR field and 1 (result column field) and none of them worked.
This is just one of my tests:
SELECT SUBSTR(f850nfac,2,4) as cpues, f850grav as cgrav, f850ivai as civai, f850exen as cexen, f850tota as ctota, .t. as celijo ;
FROM &ivaventa WHERE LEFT(DTOS(f850ffac),6)==thisform.peri GROUP BY CPUES NOCONSOLE INTO CURSOR cpuesto
Thank you.
Héctor