>>SELECT ig.ItemGroup, SUM(Cost) AS SumCost >> FROM ( SELECT Item AS ItemGroup FROM po p1 >> WHERE NOT EXISTS ( SELECT 1 FROM po >> WHERE p1.Item <> Item AND p1.Item LIKE Item + '%') >> ) ig JOIN po ON po.Item LIKE ig.ItemGroup + '%' >> GROUP BY ig.ItemGroup >>>>