[RBASE-L] - Re: Group By

[Dawn Hast]

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