Thanks all... problem resolved. I added the additional columns to the group by.
John -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Lustig Sent: Tuesday, February 08, 2005 11:10 AM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: DBedit Popup Menu (Distinct Values) > 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
