[aypinki]

Сообщение от Аватар;1334329

GROUP BY по наименованию и SUM(количество)
И Table в пролете, только Query

Код:

Select  pl1.Datemy,pl1.Amount, Nomenclature.Name1,composition.Code_of_part, SUM(composition.Amount), nom1.Name1
From 'plan' as pl1
Left outer join nomenclature on nomenclature.Code_of_element= pl1.Code_of_product
Left outer join composition on composition.code_of_product=pl1.Code_of_product
Left outer join nomenclature as nom1 on nom1.Code_of_element=composition.Code_of_part
where pl1.Datemy>=:StartDate and  pl1.Datemy<=:StartDate
Group by  nom1.Name1

правильно ли?