Thanks for the tip, It worked!!!!!
Thanks a lot!!!
Daniel Hernández.
Tijuana, BC, México.
"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_here
group by ...<[EMAIL PROTECTED]>
Join Excite! - http://www.excite.com
The most personalized portal on the Web!
