Re: Incorrect results from sum
- Date: Tue, 15 Apr 2008 16:11:22 +0200
- From: Sebastian Mendel <lists@xxxxxxxxxxxxxxxxxx>
- Subject: Re: Incorrect results from sum
Perrin Harkins schrieb:
On Tue, Apr 15, 2008 at 4:21 AM, Sebastian Mendel
<lists@xxxxxxxxxxxxxxxxxx> wrote:
use UNION
You can't use UNION to add the results of two queries. It would
return two rows.
of course!
you need to use this UNION as subquery
sorry for being not imprecise
--
Sebastian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx