See
Re: Change in SQL commands! Message #
941774>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>>>
>
>sean
>
>Oh,is that have to insert the group as many as field insert to view? Y??
--sb--