I have also faced similar problems when I use the group by clause in query. It will only give results for those items that have 1 or more records.
I handle it through php. I store the SQL result-set in an array and then separately fetch another array from the master table, where all the items are likely to be listed. Then I compare them, and any item missing from SQL result-set is marked 0. Hope this is clear. -- Tapan Shah http://www.tapan.in/ http://www.assetonline.in/ [Non-text portions of this message have been removed]
