Hi anyone,
I realize that VFP8 is now more 'purest' with SQL expressions. But what would be wrong with the following that would render error "SQL: GROUP BY clause is missing or invalid." (FWIW, this code sample was created by Query Designer.)

Thanks for any ideas,
Steven-
----------------------------------------------------

SELECT Detail.*, Codes.desc;
 FROM ;
     detail ;
    LEFT OUTER JOIN codes ;
   ON  Detail.bccode = Codes.code;
 GROUP BY Detail.bccode;
 ORDER BY Detail.bccode