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) =3D n
[/snip]

SELECT t1.c1 + t2.c2 + t3.c3 FROM table WHERE id =3D n

The above doesn't work I'm afraid.
Peter