Hi Priscilla,
you can do:
SELECT (SELECT SUM(t1.field) FROM table1 t1) +
(SELECT SUM(t2.field2) FROM table t2) +
(SELECT SUM(t3.field3) FROM table t3)
/Johan
Priscilla Labanca wrote:
Hi, guys!
I need to sum three fields of three different tables.... how can I do?
Thank you very much.
Priscilla.
---------------------------------
Promoção Yahoo! Acesso Grátis: a cada hora navegada você
acumula cupons e concorre a mais de 500 prêmios! Participe!
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.12.6/151 - Release Date: 2005-10-28
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
