25.04.2005, 17:25
общий
это ответ
Здравствуйте, Масюк Сергей!
Попробуй так:
select id, sum (b1) as sum_bonus1, sum (b2) as sum_bonus2, sum (b3) as sum_bonus3
from (
select id, sum (bonus) as b1, 0 as b2, 0 as b3
from MY_TABLE
where date between START_DATE and END_DATE and
id_bonus = 1
group by id
union all
select id, 0 as b1, sum (bonus) as b2, 0 as b3
from MY_TABLE
where date between START_DATE and END_DATE and
id_bonus = 2
group by id
union all
select id, 0 as b1, 0 as b2, sum (bonus) as b3
from MY_TABLE
where date between START_DATE and END_DATE and
id_bonus = 3
group by id
)
group by id