Hello Steve,
El 20/01/2005 5:20 PM, Steve Crawford en su mensaje escribio:
> select
> zert_title as TITULO,
> sum(case when epr_mes=200309 then epr_valor else 0 end) as "200309",
> sum(case when epr_mes=200310 then epr_valor else 0 end) as "200310",
> sum(case when epr_mes=200311 then epr_valor else 0 end) as "200311",
> sum(case when epr_mes=200312 then epr_valor else 0 end) as "200312"
> group by 1;
That works ok, but start and end month are variables, user can choose them.
Thanks,
--
Sinceramente,
Josué Maldonado.
"Los estupidos adolecentes son los que se reunen por las noches a
consumir drogas y a planear los ilicitos."
