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
