[snip] 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. [/snip] Don't be afraid, you must join the tables -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]