create calculated column based on 3 tables

i have 3 tables as follows 

table 1 : 

table 2 : 

table 3 : 

i need to get the sum of table1[value] and instert it as a column in table[3] as i will make extra calculations after this

Relations are as follows:

table1[code] & table2[code] , many to one.

table2[type] & table3[type] , one to many.

id column in table1 and table 3 has duplicates