Hi, One possible way would be to the UNION statement - I think this would be your best action, providing the data is consistent across all three tables.
See: http://dev.mysql.com/doc/refman/5.0/en/union.html Hope this helps, Paul -----Original Message----- From: Priscilla Labanca [mailto:[EMAIL PROTECTED] Sent: 31 October 2005 12:03 To: [EMAIL PROTECTED] Cc: Gleb Paharenko; mysql@lists.mysql.com Subject: Re: How can I do? 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! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]