select l2.categoryCode, l2.categoryDescription, l2.commissionTypeCode, l2.commissionRate, l1.commissionTypeCode l1CommissionType, avg( l1.commissionRate ) l1CommissionRate, count( distinct l1.itemId ) l1Count from #request.fmDatabase#.dbo.ManufacturerItemCategories l2 left outer join #request.fmDatabase#.dbo.Items l1 on l1.manufacturerItemCategoryId = l2.manufacturerItemCategoryId where l2.manufacturerId = 2 group by l2.categoryCode, l2.categoryDescription, l2.commissionTypeCode, l2.commissionRate, l1.commissionTypeCode order by l2.categoryCode, l2.categoryDescription, l1.commissionTypeCode

#htmleditformat( categoryCode )#

#htmleditformat( categoryDescription )#

#htmleditformat( commissionTypeCode )#

#commissionRate#

#l1Count#

#l1CommissionType#

#l1CommissionRate#