Excel Forum

Code: Select all

SELECT [Prod_ Order No_]
      ,[Item No_]
	  ,[Line No_]
	  ,sum([Add Round Before (Print)]) as [Add Round Before (Print)]
      ,sum([Add Round After (Print)]) as [Add Round After (Print)]
	  ,sum([Round Print]) as [Round Print]
	  ,sum([Add Round Before (Print)] + [Add Round After (Print)] + [Round Print]) as [Total Round Print]
	  ,[No_ of Cut Size]
	  ,[No_ of Work]
	  
  FROM [_PROD].[dbo].[$Prod_ Order Component]
  where [Location Code] in ('PAPER') and [Prod_ Order No_] ='RP21040211'
  group by [Prod_ Order No_],[Item No_],[No_ of Cut Size],[No_ of Work],[Line No_]