Because these are two quite distinct queries, I don't see an immediate way of joining them that would make them more efficient. Something that comes to mind are sub-select statements for example, but that would make this more complex than it needs to be.
Like Robert said, you aren't giving us a great deal to go on. just knowing the output expected is nowhere near enough, If these are the only two partners in the table, perhaps an aggregate would serve your purpose, If you are looking at simplifiying your query, perhaps a stored proc is more what you are after. With more data, we can probably be more helpful. Colin On Thursday 03 September 2009 11:47:17 pm sangprabv wrote: > 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
