Calculating sum of the amounts of each Airports automatically

Hello,
I have TWO tables such as below,according to the First Table :the first column (Airport name) the second column is ( the amounts in USD)

the first table :

Airport name U.S.D
ALY 111,447.70
ALY 559,557.23
LXR 12,827.16
LXR 279,720.62
HRG 1,353.77
HRG 1,187,334.08
SSH 8,417.65
SSH 2,900,602.08
TCP 6,363.41
TCP 90,279.68
TCP 18,567.52


the second table:

airport name the total Amount of each airport
ALY 671,004.93
LXR 292,547.78
HRG 1,188,687.85
SSH 2,909,019.73
TCP 115,210.61

According to the second table, the first Column (airports name)and the second Column ( the total amounts of a specific airport).
All I need is to make the second column in the second table calculates the SUM of the amounts of each Airports automatically with reference to the first table.