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<sangpr...@gmail.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 To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org