>Hi,
>I have a problem with Group by Clause when i try to group some row data from table/view(try both)when create a view or query. The error msg prompt to me is (SQL: Group BY clause is missing or invalid.).Then, i just remove the group,but the msg still prompt to me. What wrong with it? Pls help me, i'm a beginer of foxpro. Thsnks a lot>>>
>

In VFP 8 and later, when a query uses GROUP BY, every field in the field list must either appear in the GROUP BY clause or use one of the aggregate functions (SUM(), COUNT(), etc.).

Tamar