Doesn't the group by column order have to match the select order? Marc
----- Original Message ----- From: jan johansen To: RBASE-L Mailing List Sent: Thursday, June 26, 2008 12:46 PM 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
