Yes! I was using one of my previous samples that had some computed columns that you don't have to reference so I forgot.
-----Original Message----- From: "Marc" <[EMAIL PROTECTED]> To: [email protected] (RBASE-L Mailing List) Date: Thu, 26 Jun 2008 12:54:31 -0500 Subject: [RBASE-L] - Re: Group By 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
