Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: Robert Citek (rwcitekalum.calberkeley.org)
Date: Thu Sep 03 2009 - 22:11:00 CDT
It's not clear what exactly you are looking for. Two possible solutions:
1) use a union
2) use a join with another table containing partner and factor fields.
Can you give a short example of what the input looks like and what you
would like the output to look like?
On Thu, Sep 3, 2009 at 10:46 PM, sangprabv<sangprabvgmail.com> wrote:
> I have these query:
> SELECT SUM(price)*0.5 AS price1 FROM table WHERE partner = 'A';
> SELECT SUM(price)*0.65 AS price2 FROM table WHERE partner = 'B';
> Is it possible to make the queries into 1 single query? How to make it
> happen? Many thanks for helps.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql