Group Select in an Only row

SELECT 
    loadNumber, 
    CASE 
        WHEN E.Clave = 'LOD' THEN FechaEvento 
        ELSE NULL 
    END AS 'Load Date USA', 
    CASE 
        WHEN E.Clave = 'DAA' THEN FechaEvento 
        ELSE NULL 
    END AS 'Colocacion AA',
    CASE 
        WHEN E.CLAVE = 'RPD' THEN FechaEvento 
        ELSE NULL 
    END AS 'Docs Listos',
    CASE 
        WHEN E.Clave = 'IDT' THEN FechaEvento 
        ELSE NULL 
    END AS 'Llegada MX',
    CASE 
        WHEN E.Clave = 'ULD' THEN FechaEvento 
        ELSE NULL 
    END AS 'Descarga MX'
FROM
    OrdenEvento OE
INNER JOIN 
    Evento E ON OE.idEvento = E.ID
WHERE 
    loadNumber = '60317'
GROUP BY 
    loadNumber, e.Clave, FechaEvento

I have this SQL, trying to gather all in one single row. My goal if there is a number that match with the cases enter and if there is not a single row with full NULL Values, or only a few matches and others with Null Values

This is the current result
and this is the wanted result

>Solution :

You need some aggregation to collapse all those rows to one row per loadNumber.

That also means your GROUP BY should only be loadNumber.

SELECT
  loadNumber, 
  MAX(CASE WHEN E.Clave='LOD' THEN FechaEvento ELSE NULL END)   AS 'Load Date USA', 
  MAX(CASE WHEN E.Clave='DAA' THEN FechaEvento ELSE NULL END)   AS 'Colocacion AA',
  MAX(CASE WHEN E.CLAVE='RPD' THEN FechaEvento ELSE NULL END)   AS 'Docs Listos',
  MAX(CASE WHEN E.Clave='IDT' THEN FechaEvento ELSE NULL END)   AS 'Llegada MX',
  MAX(CASE WHEN E.Clave='ULD' THEN FechaEvento ELSE NULL END)   AS 'Descarga MX'
FROM
  OrdenEvento OE
INNER JOIN
  Evento E
    ON OE.idEvento=E.ID
WHERE
  loadNumber='60317'
GROUP BY
  loadNumber