Tables/sum

[Peter South]

Ok here is what I'm trying to do.

         Table 1                                          Table 2               
                               Table 3
Column1(id)      Column2 (score)          Column1(id)   Column2(score)          
  Column1(id)   Column2(name)  
1                        10                                    1                
   15                                1                    Fred
2                        10                                   2                 
  (no score)                    2                   Jim  
3                      (no score)                         3                    
15                               3                    Joe



The result I want is 
Fred scored 25 (or) 
Joe scored 15 (or)
Jim scored 10.
Peter