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 crsBI would like to combine these in such a way that all the fisyears in the table, not just the first one. Can someone help?