I don't think that firebirdsql supports cross tabulation queries..

Z T




________________________________
From: Ahmad $arhan **** <mahdoom_a@...>
To: FireBird <firebird-support@yahoogroups.com>
Sent: Tuesday, February 2, 2010 10:48:25
Subject: [firebird-support] SQL statment?


hello everybody,

I need to know the SQL statment or whatever for retreving summation of costs for every month of each account ...how to group it

the from have 4 boxes, 2 are (from-date) & (to-date) continuoslly
2 are (from-account) & (to-account) selective.



sample:

01-01 03-02 05-05 ......etc
jan
feb
mar
aprl
may
jun
.
.
.
etc


thanks in advance.

sarhan




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



------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links




New Email names for you!
Get the Email name you've always wanted on the new @ymail and @rocketmail.
Hurry before someone else does!
http://mail.promotions.yahoo.com/newdomains/aa/

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