Rousseau Sennett

Rousseau Sennett

  • NA
  • 31
  • 42.8k

Merge 2 Tables

May 20 2011 4:58 AM
I'm sure the answer to this is obvious but I'm a newbi so here it goes...
I'm working in vs 2010 C# and i'm trying to create a Table adapter in my Data set to do the following

Ok I've got 2 tables
Invoices         Credits
======         =======
Invoice#        ID(int, auto increment)
Date             Date
Debitor          Debitor
X                 X
X                 X
Total            Amount

It would be easy to just draw up the 2 tables between dates nd compate balances. but i would like statement to sort it according to the date for
a single Debitor. to look somthing like this

Date                DR                CR
=====             ================
2011/05/01       150.00
                                         100.00

When I use joins in my SQL Select Query it end up looking like this

2011/05/01      150.00           100.00

Is there a more advance Query I should use so every entry from each table creates its own row when creating my table adapter ?
Or is there a totaly different angle I should be ding this from ? O and I'm using windows Reporting.

Any help would be appreciated

Thx Rousseau


Answers (2)