Re: Multiple counts as an array

[Sasha Pachev]

How about this:

You first initialize a Perl associative array %counts setting the value
for each description to 0. Then run select count(*), descript from t1
group by descript, iterate through the results setting the values of the
associative array. Then iterate through the array and print out the
results. The items that were not there will have the count of 0. This
should be faster than the left join if you have only 12 items to deal
with.

-- 
Sasha Pachev
http://www.sashanet.com