Drill trough lines

[andisu]

Hello i have a table like this
TABLE

SON	FATHER	VALUE
1	1	500,00
2	1	200,00
3	1	300,00
4	2	100,00
5	5	400,00

and i need to do an report like this
Report:

Reg	Total Value
1	1100,00 (sum(sons 1,2,3,4))
2	300,00 (sum(sons 2,4))
3	300,00 sum son 3
4	100,00 sum son 4
5	400,00 sum son 5

But i have no idea how can i join the lines, cause i have an variable number of sons and fathers like a tree. Can you help me?
Thanks!

[adik]

you will havet use analytical functions like this:
total(value for father)