From: sangprabv (sangprabvgmail.com)
Date: Thu Sep 03 2009 - 22:47:17 CDT

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

What I'm looking for is to SUM the price from partner A and B with each
result. So the result I expect is like "Partner A total's price 123,
Partner B total's price 456". Can you give me the query example? TIA.

Willy

On Thu, 2009-09-03 at 23:11 -0400, Robert Citek wrote:
> 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 ]