select cr.ShortName, SUM(DocDetail.PriceRelis*DocDetail.Quantity)
FROM DocHeaders INNER JOIN DocDetail ON DocHeaders.ID=DocDetail.id
left join Contragents on Contragents.id=DocHeaders.Client
left join Contragents сr on Contragents.MatPath like cr.MatPath+'.%'