MySQL Forums
Forum List  »  Newbie

How to get this result....
Posted by: Aljosa Motore
Date: February 28, 2007 12:08AM

I have table with next data:
Col.A | Col.B | Col.C
-10 | A | D
-2 | A | R
-3 | B | D
-1 | B | R

What I want is to get next result:
Col.B | Col.A | Desription not in result query
A | -8 | -10-(-2)
B | -2 | -3-(-1)

I am trying for several days without any progress. Can anybody halp me?



Edited 1 time(s). Last edit at 02/28/2007 12:15AM by Aljosa Motore.

Options: ReplyQuote


Subject
Written By
Posted
How to get this result....
February 28, 2007 12:08AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.