I have to tables:
Id ContrSum ContrDate
-- -------- ---------
1 100.00 2004/10/10
2 200.00 2004/10/11
...
Id PayedSum PayedDate
-- -------- ---------
1 50.00 2004/10/10
1 20.00 2004/10/11
1 10.00 2004/10/12
1 20.00 2004/10/13
2 200.00 2004/10/11
I want the following table
Id ContrSum ContrDate PayedSum PayedDate
-- -------- ---------- -------- ---------
1 100.00 2004/10/10 50.00 2004/10/10
1 0.00 20.00 2004/10/11
1 0.00 10.00 2004/10/12
1 0.00 20.00 2004/10/13
2 200.00 2004/10/11 200.00 2004/10/11
Is that possible. The first table is master table & I right join table.
TIA
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
