From: Robert Citek (rwcitekalum.calberkeley.org)
Date: Thu Sep 03 2009 - 22:11:00 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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?

Regards,
- Robert

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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]