Hello All,
I want to sum a column from several tables while using UNION.. something
like this:
(SELECT SUM(price) FROM table1)
UNION
(SELECT SUM(price) FROM table2)
This results in 2 rows that sums each table seperatedly.. but I want to sum
the column from both tables together..
I usually have more than 2 tables to sum, and I sum different tables every
time, so I can't define merge tables on every combination..
Is there a way to sum the column from all tables together?
thanks in advance,
-Lorderon.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
