TABLE 1
projectName REV Budget
aaa 0 1.0
aaa 1 2.0
bbb 2 3.0
ccc 1 4.0
bbb 2 5.0
ddd 1 6.0
eee 1 7.0
aaa 2 8.0
TABLE2
projectName Type
aaa M
bbb N
ccc M
ddd M
eee N
For the above two tables, I want to use query to get the capacity sum of higher revision of project for each Type. like the following:
M 18 (=8.0+4.0+6.0)
N 12 (=5.0+7.0)
Is there any way to do this?
projectName REV Budget
aaa 0 1.0
aaa 1 2.0
bbb 2 3.0
ccc 1 4.0
bbb 2 5.0
ddd 1 6.0
eee 1 7.0
aaa 2 8.0
TABLE2
projectName Type
aaa M
bbb N
ccc M
ddd M
eee N
For the above two tables, I want to use query to get the capacity sum of higher revision of project for each Type. like the following:
M 18 (=8.0+4.0+6.0)
N 12 (=5.0+7.0)
Is there any way to do this?
