Tables/sum

[Peter South]

Can anyone tell me how to add up values in different tables? For example 
Table1.Column1 + Table2.Column2 + Table1.Column3 Where id(row) = n
Thanks
Peter