Hi Jim, Thanks for the tip, It worked!!!!!Thanks a lot!!!Daniel Hernndez.Tijuana, BC, Mxico."More you learn, more you earn".try select ...,sum(case when sales.itemname = 'some' then sales.count else 0 end) as "Sales Candies"from your_table_heregroup by ...
_______________________________________________
Join Excite! - http://www.excite.com
The most personalized portal on the Web!