Can you try ORDER BY instead of GROUP BY to see if you get the desired results?
________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of jan johansen Sent: Thursday, June 26, 2008 12:46 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Group By I always seem to not get his right. What is wrong with this? SET ERROR MESSAGE 677 OFF DROP VIEW tCustInvoiceView SET ERROR MESSAGE 677 ON CREATE TEMPORARY VIEW `tCustInvoiceView` + (CUSTNO,INVOICE#,DELDATE,NETSALE$,paid_YN) + AS SELECT + CUSTNO,INVOICE#,DELDATE,NETSALE$,paid_YN + FROM DAYSALES + GROUP BY CUSTNO, INVOICE# gives an error message -ERROR- Illegal column specification (2512) If I leave off the group by it works fine. Jan
