table A
-----------------
a_id | user _a |
-----------------
1 |adam |
2 |jose |
3 |adam |
4 |adam |
5 |anne |
6 |jose |
table B
--------------------------------------
b_id | user_b | value1 | value2
--------------------------------------
1 |adam | 33 | 9
2 |jose | 46 |88
3 |adam | 77 |21
4 |adam | 81 |15
5 |anne | 11 |67
6 |jose | 45 |6
table C
--------------------------------------
c_id | user_c | value1 | value2
--------------------------------------
1 |adam | 33 | 9
2 |jose | 46 |88
3 |adam | 77 |21
4 |adam | 81 |15
table D
--------------------------------------
d_id | user_d | value1 | value2
--------------------------------------
1 |adam | 33 | 9
2 |jose | 46 |88
how can I view the total value of value1 and value2. example: I want my list view page look like this.
--------------------------------------------------------
user | total value of value1 | total value of value2
---------------------------------------------------------
adam |415 | 99
jose |183 | 270
anne |11 | 67
pls. help.