No, there's nothing special about GROUP BY. The VFP ODBC does not support derived tables. It's VFP9 feature.
Consider using CursorAdapter with VFP OLE DB provider.

>
>Yes, I think that is the problem. I am using VFP9.0 GROUP BY syntax with old ODBC. Listed below is the code I was using:
>
>

>
>lcSql = "SELECT po_d.rcv_numb, po_d.por_numb, po_d.ven_numb, po_d.usr_code, cTemp.nRcv_totl ;
>		FROM (SELECT po_d.rcv_numb, SUM(po_d.por_txam + po_d.por_ntam) 
AS nRcv_totl FROM po_d GROUP BY po_d.rcv_numb) AS cTemp ;
>		INNER JOIN po_d ON cTemp.rcv_numb = po_d.rcv_numb ;
>		ORDER BY po_d.rcv_numb "
>
>=ExecuteSql(lcSQL, "cPo_d")
>
>

>
>