RE: Cross Tab Query

From: Nigel Rivett (sqlnr_at_hotmail.com)
Date: 02/06/05 

Date: Sun, 6 Feb 2005 10:29:02 -0800

select year ,
A = (select QTY from tbl t2 where t.year = t2.year and item = 'A') ,
B = (select QTY from tbl t2 where t.year = t2.year and item = 'B') ,
C = (select QTY from tbl t2 where t.year = t2.year and item = 'C')
from tbl t
group by year
order by year