Fantástico! Buenisimo! Genio
poliburro!
lo único que cambie fue kg1 + kg2 + kg3 por Kg1, kg2 y kg3
Código SQL
[-]
Select Acumulados.Codigo, Sum(Kilos) As TotalKilos
From (
Select Cod1 Codigo, Sum(kg1) As Kilos
From Tabla
Group By Cod1
Union ALL
Select Cod2 Codigo, Sum(kg2) As Kilos
From Tabla
Group By Cod2
Union ALL
Select Cod3 Codigo, Sum(kg3) As Kilos
From Tabla
Group By Cod3
) As Acumulados
Group By Acumulados.Codigo
Muchas Gracias!
