how to calculate between two columns from diffrent tables?

[davidi4524]

hi, i have two tables , one is a branch table wichh includ the branch name and profit target.

and another table wich inculde branche and total profit.

i whant to create a colum tahat make a "branch profit targer - total profit.

for example: cranch number one - the profit target is 1500

and the total profit is 2100

i whant to to 2100 - 1500 = 600

so the colum will show "600".

thanks for respondes.

david.