Re: Incorrect results from sum

[Sebastian Mendel]

Perrin Harkins schrieb:

On Tue, Apr 15, 2008 at 4:21 AM, Sebastian Mendel
<[EMAIL PROTECTED]> 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/[EMAIL PROTECTED]