>Here is a pair of SELECTs that order a table of monthly revenue postings by category into columns by month. Some months are left out for simplicity.
>

>select dist fisyear from rta_revenues order by fisyear into cursor crsA
>
>select dist category, ;
>		nvl((select amount ;
>		from rta_revenues ;
>		where fisyear = crsA.fisyear and ;
>		category = crsB.category and ;
>		month(receiveddate) = 9),0) as sep , ;		
>		nvl((select amount ;
>		from rta_revenues ;
>		where fisyear = crsA.fisyear and ;
>		category = crsB.category and ;
>		month(receiveddate) = 10),0) as oct , ;
>		nvl((select amount ;
>		from rta_revenues ;
>		where fisyear = crsA.fisyear and ;
>		category = crsB.category and ;
>		month(receiveddate) = 11),0) as nov , ;
>		crsA.fisyear as fisyear ;
>		from rta_revenues crsB
>

>
>I would like to combine these in such a way that all the fisyears in the table, not just the first one. Can someone help?
>Thanks

The question is unclear. Whare result you're currently getting and what do you want? Can you show some data samples?

Thanks.