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