Steven,
You must include all non-aggregate columns in the GROUP BY clause. You have no aggregate columns so why are using the GROUP BY clause at all?
Regards.
>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
>
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao