Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi together,
I have the following issue:
I have two concatenated tables
Type ID Date Ammount
1 001 01/10/2010 102
1 001 10/10/2010 56
1 002 02/10/2010 85
2 001 05/10/2010 100
2 002 03/10/2010 200
1 001 01/09/2010 55
.........
So I want to create new table with the same structure and Ammount=sum(ammount) where Type=2 - sum(ammount) where Type=1 for every month
Hi,
can you upload a Example?