Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: sangprabv (sangprabvgmail.com)
Date: Thu Sep 03 2009 - 22:47:17 CDT
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.
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?
> - 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