I do have a query like: SELECT TYPE, TOTAL from Transaction
which results something like:
TYPE TOTAL
BUY 2000
SELL 1000
SELL 500

However I would like to have the result like this
BUY + 2000
SELL - 1000
SELL - 500

So depending on the TYPE there will be a + / - before the TOTAL.
How can I make that happen ?

Thanks

John

PS: feel free to send suggestions to my private emailaddress