I've got 3 tables which I've outlined below. What I'm trying to display is the 'UserName' from table1 along with the sum of 'Money' from table 3 where 'FriendName' in table2 = 'FriendName' in table3.

So the end result would display. Any help would be appreciated.
Bill 150
Ben 50
Frank 0

Table1
ID UserName
1 Bill
2 Ben
3 Frank

Table2
UserID FriendName
1 Steve
1 John
2 Steve
3 Luke

Table3
FriendName Money
Steve 50
Mark 30
John 100