I am joining two tables (Checks and Deposits) into a common dataset for an SSRS report.
In many cases I find one deposit and several checks for the same account. Makes sense.
How can I join the tables in a way that displays the deposit one time and each check individually?
I thought of creating two tables and doing a lookup in the report, but the same problem would exist of the deposit appearing multiple times depending on how many checks appear in the data.
I'm posting here, because I'm looking for a T-SQL solution, not an SSRS solution.
Does anyone have any ideas how I can approach this puzzle?
Thanks1
No comments:
Post a Comment