469,126 Members | 1,256 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,126 developers. It's quick & easy.

Somewhat complex report

Hi

I really hope someone can assist me with this. I need a query that'll return data that looks something like:

Card Account Card Number #Transactions March April May June July ...
-------------------- ------------------- -------------------- --------- ------- ------ ------- -------

Card Account comes from Table A
Card Number from Table B
# of transactions from Table C
For Months (march - december) a total number of transactions is needed and this comes from Table C.

What confuses me is that I need to get Card Account Number and the matching Card Number, then I think some sort of a loop needs to be done to get the data broken down by months.

Any suggestions are appreciated.

Thanks.
Feb 21 '07 #1
0 832

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Charles E. Pelkey | last post: by
3 posts views Thread by AstrA | last post: by
3 posts views Thread by Wired Hosting News | last post: by
4 posts views Thread by BiDi | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.