select Year, Month, Sum(Sales) from sales group by Year, Month
will work
You could create a view of this and then make your select but do you want
January from 1999, 2000, 2001 etc all grouped together?
Alan
-----Original Message-----
From: arnorog [mailto:arno.rog@...]
Sent: Wednesday, 28 August 2002 20:18
To: ib-support@yahoogroups.com
Subject: [ib-support] Newbie question IB about select


Hello,

I am a newbie to IB.

In MySQL I can use the next select:

select Year, Month, SUM(Sales) from sales group by Month;

However, this does not seem to work in IB.

I've figured a way around it using:

select MIN(Year), MIN(Month), SUM(Sales) from sales group by Month;

Is this supposed to be?

Kind regards,

Arno Rog
Amsterdam



Yahoo! Groups Sponsor
ADVERTISEMENT



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]