I have two tables:
Table A:
Code | Name
100 | Name A
200 | Name B
300 | Name C
Table B:
Code | Date | Qty | Value
100 | 2007-01-01 | 10 | 123
100 | 2007-02-01 | -2 | 300
200 | 2007-02-01 | 3 | 100
What I want is to get this result:
Result Table on date example 2007-01-05:
Code | Name | Qty |
I have table with next data:
Col.A | Col.B | Col.C
-10 | A | D
-2 | A | R
-3 | B | D
-1 | B | R
What I want is to get next result:
Col.B | Col.A | Desription not in result query
A | -8 | -10-(-2)
B | -2 | -3-(-1)
I am trying for several days without any progress. Can anybody halp me?
Actualy I