> There are three... MFGCODE,MFG_STYLE,MFG_DESC > I tried with a single col lookup and it got the same error message.
In a GROUP BY select, all columns in the SELECT list must appear in the GROUP BY clause, unless the column in enclosed in one of the standard SQL aggregate functions (MIN, MAX, AVG, COUNT, SUM) or the R:Base specific LISTOF function. In your case, you either need to add MFGCode and MFG_Desc to the GROUP BY clause, remove them from the column list, or enclose them in one of the functions mentioned above. -- Larry
