[RBASE-L] - RE: Group by -- need another set of eyes

[Bernard Lis]

Hi Sami,
You mean like this:

sel CreditDate,sum(Creditamount)=s from Credits  where Creditdate between 
3/1/2008 and 3/31/2008 group by CreditDate
CreditDate sum (Creditamou
---------- --------------- 
03/23/2008        2,952.16
03/30/2008        2,819.19
03/23/2008        2,952.16
03/30/2008        2,819.19
---------- --------------- 
                 11,542.70

----- Original Message ----- 
From: "Sami Aaron" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <rbase-l@rbase.com>
Sent: Wednesday, April 23, 2008 11:58 AM
Subject: [RBASE-L] - RE: Group by -- need another set of eyes


Bernie -

The WHERE clause comes before the GROUP BY clause:

sel CreditDate,sum(Creditamount)=s from Credits +
 where Creditdate between 3/1/2008 and 3/31/2008 +
 group by CreditDate

Sami
____________________________
Sami Aaron
Software Management Specialists
913-915-1971
[EMAIL PROTECTED]



-----Original Message-----
From: rbase-l@rbase.com [mailto:[EMAIL PROTECTED] On Behalf Of Bernard 
Lis
Sent: Wednesday, April 23, 2008 10:52 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Group by -- need another set of eyes

Can anyone see what's wrong here?
Why is this duplicating?

CreditDate sum (Creditamou
---------- --------------- 
03/23/2008        2,952.16
03/30/2008        2,819.19
03/23/2008        2,952.16
03/30/2008        2,819.19
---------- --------------- 
                 11,542.70