>select crsB.category, jul, [fisyear] >from (select distinct category from [RTA-Revenues]) as crsA >inner join ( >select [fisYear], [category], >CASE WHEN month([receiveddate])=7 THEN sum(AMOUNT) ELSE CAST(0 AS numeric(12,2)) END as Jul >from [rta-revenues] >group by receiveddate, FISYEAR, CATEGORY) as crsB >on crsA.CATEGORY = crsB.CATEGORY >order by FISYEAR >>