Hi Jaekarp,

>Sorry for delayed response, Matt.

No problem - thanks for replying.

>I looked up the book that covers Standard SQL and it says..
>
>" SELECT select_list
> FROM table_list
> [ where condition ]
> GROUP BY group_by_list
> In most SQL dialects, every item in the GROUP BY list must be a column name
>(not an expression) and must be equivalent to or a subset of select list items - you can make groups only out of things you select . "

That's reasonable. However, Oracle seems to also want every field in the select_list to appear in the group_by_list.

I solved my problem by pulling the data from Oracle into a VFP cursor, and then selecting from that cursor. VFP allowed me to group by whatever I wanted.

Best.

Matt.