Dawn, Not enough coffee today. This particular client uses invoices that don't have header and detail so I needed a way to just show one invoice number for 10 details and such. But now that I look at the tables again the one I was playing with actually does have the total and so each row is unique.
Sorry for clogging the list today. Jan -----Original Message----- From: "Dawn Hast" <[EMAIL PROTECTED]> To: [email protected] (RBASE-L Mailing List) Date: Thu, 26 Jun 2008 13:52:38 -0400 Subject: [RBASE-L] - Re: Group By Jan, When using Group by, the group by clause has to include all the columns in your select, except for the column you're aggregating (sum, min, max, avg...). I don't see you aggregating any column here, so I'm wondering what you're trying to show in your view. Dawn ----- Original Message ----- From: jan johansen To: RBASE-L Mailing List Sent: Thursday, June 26, 2008 1: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
