Re: How to get this result....

[Felix Geerinckx]

Aljosa Motore Wrote:


> 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)

SELECT
    ColB,
    SUM(IF(ColC = 'D', ColA, -ColA))
FROM foo
GROUP BY ColB

--
felix
Please use BBCode to format your messages in this forum.