Fórum Sql com Group By #59716

SELECT MVE_LOTESERIAL LOTE,
  PRD_PN PN,
  MVE_DATADOCTO DATA,
    sum(case when Mve_Operacao=´E´ then Mve_Qtde else 0 end) TotEntrada,
    sum(case when Mve_Operacao=´S´ and Tpf_Cod <> ´03´ then Mve_Qtde else 0 end) TotSaida
      FROM ESTOQUE
        WHERE PRD_PN = ´T-AA´
          AND MVE_LOTESERIAL = ´A701´
            GROUP BY 1,2,3
UNION

SELECT MVE_LOTESERIAL LOTE,
  mve_partnumbermp PN,
  MVE_DATADOCTO DATA,
    sum(case when Mve_Operacao=´E´ then Mve_Qtde else 0 end) TotEntrada,
    sum(case when Mve_Operacao=´S´ and Tpf_Cod = ´03´ then Mve_QtdeTotalMP end) TotSaida
      FROM ESTOQUE
        WHERE MVE_PARTNUMBERMP = ´T-AA´
          AND MVE_LOTESERIAL = ´A701´
            GROUP BY 1,2,3

UNION

SELECT MCJ_LOTESERIAL LOTE,
  MCJ_PARTNUMBER PN,
  MCJ_DATADOCTO DATA,
    SUM(MCJ_QTDE-MCJ_QTDE) TOTENTRADA,
    SUM(MCJ_QTDE) TOTSAIDA
      FROM ESTOQUECONJUNTO
        WHERE MCJ_PARTNUMBER = ´T-AA´
          AND MCJ_LOTESERIAL = ´A701´
            GROUP BY 1,2,3
              ORDER BY 3,1