Untitled

SELECT T1.[SlpCode] AS 'Vendedor', T0.[SlpName] AS 'Nome do vendedor', T1.[CardCode] AS 'Código do cliente/fornecedor', T1.[CardName] AS 'Nome do cliente/fornecedor', T2.[ItemCode] AS 'Nº do artigo', T2.[Dscription] AS 'Descrição do artigo/serviço', sum(T2.[LineTotal]) AS 'Total da linha' FROM  [dbo].[OSLP] T0  INNER  JOIN [dbo].[OQUT] T1  ON  T1.[SlpCode] = T0.[SlpCode]   INNER  JOIN [dbo].[QUT1] T2  ON  T2.[DocEntry] = T1.[DocEntry]   INNER  JOIN [dbo].[OSLP] T3  ON  T3.[SlpCode] = T2.[SlpCode]   WHERE T2.[LineStatus] = (N'O' )   GROUP BY T1.[SlpCode], T0.[SlpName], T1.[CardCode], T1.[CardName], T2.[ItemCode], T2.[Dscription]