Hi Mike,
It's a table, not a view -- but thanks for thinking about it anyway.
Bernie Lis
----- Original Message -----
From: "Ramsour Mike" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Wednesday, April 23, 2008 12:09 PM
Subject: [RBASE-L] - RE: Group by -- need another set of eyes
Bernard:
Is this based on a table or a view? If it's a view does it by any chance
have a UNION clause in it? I have experienced something similar when
using
a view with a UNION to determine correct data types.
Mike Ramsour
AK Steel Coshocton Works
Quality Department
Phone/VMS: 740-829-4340
-----Original Message-----
From: Bernard Lis [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 23, 2008 12:04 PM
To: [email protected]
Subject: [RBASE-L] - RE: Group by -- need another set of eyes
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
