471,581 Members | 2,513 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,581 software developers and data experts.

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 954

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
reply views Thread by XIAOLAOHU | last post: by
reply views Thread by leo001 | last post: by
reply views Thread by Vinnie | last post: by
1 post views Thread by lumer26 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.