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.
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.