Calculated table based on 2 different tables.

Hello everyone,    Newbie here! Any help would be very much appreciated!   Table 1 (unique ID) Net amount based on uniques ID ID  net 1 200 10 -300 8 -60 9 100 12 150 ...