Hola a todos,estoy utilizando Delphi 6, la BD está hecha en Access y utilizo los componentes ADO; la consulta es la siguiente.
Código SQL
[-]SELECT C.Codigo, Sum(FA.Total) AS SumaTotal
FROM Clientes AS C, Facturas_Ventas_A AS FA
WHERE (C.Eliminado =False) AND (C.Codigo= FA.Codigo_Cliente) AND (C.Categoria= :unaCategoria) AND (FA.Fecha Between :FecMin And :FecMax)
GROUP BY C.Codigo
UNION ALL SELECT C.Codigo, Sum(FB.Total) AS SumaTotal
FROM Clientes AS C, Facturas_Ventas_B AS FB
WHERE (C.Eliminado = False) AND (C.Codigo = FB.Codigo_Cliente) AND (C.Categoria = :unaCategoria) AND (FB.Fecha Between :FecMin And :FecMax)
GROUP BY C.Codigo
UNION ALL SELECT C.Codigo, Sum(FC.Total) AS SumaTotal
FROM Clientes AS C, Facturas_Ventas_C AS FC
WHERE (C.Eliminado = False) AND (C.Codigo = FC.Codigo_Cliente) AND (C.Categoria = :unaCategoria) AND (FC.Fecha Between :FecMin And :FecMax)
GROUP BY C.Codigo
Lo que yo quisiera haceres que para un mismo codigo de cliente,se sumaran los campos FA.SumaTotal + FB.SumaTotal + FC.SumaTotal.
Bueno, si alguien puede ayudarme desde ya muchas gracias. Saludos.
Luana