>>Now I'm getting:
>>
>>"Column 'Product.sProduct_Desc1' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause."
>>
>>I don't understand why all the columns listed in the SELECT clause have to be in the GROUP BY clause.
>>
>>Can you enlighten me?
>
>If column is not in the GROUP BY clause than SQL engine wouldn't know what record it should come from. IOW, you did not provide enough info for SQL Engine to perform the query.


"....than SQL engine wouldn't know what record it should come from"

Huh?? I don't get this.