Unir el contenido de 2 campos iguales sin repetir

[[poliburro]]

Empezado por chinosoft

Holas!

1| cod1 = FR-688 cod2 = FR-760 cod3 = FR-987 kg1 = 4 kg2 = 6 kg3 = 1
2| cod1 = FR-987 cod2 = FR-688 cod3 = FR-688 kg1 = 1 kg2 = 5 kg3 = 5

FR-688 | 14
FR-760 | 6
FR-987 | 2

Código SQL [-]
Select Acumulados.Codigo, Sum(Kilos) As TotalKilos
  From (
  Select Cod1 Codigo, Sum(kg1 + kg2 + kg3) As Kilos
   From Tabla
  Group By Cod1
 Union ALL
  Select Cod2 Codigo, Sum(kg1 + kg2 + kg3) As Kilos
   From Tabla
  Group By Cod2
 Union ALL
  Select Cod3 Codigo, Sum(kg1 + kg2 + kg3) As Kilos
   From Tabla
  Group By Cod3
       ) As Acumulados
Group By Acumulados.Codigo