CCCPaste

Task 5 - SQL

SELECT

SPERSO.VORNAME,
SPERSO.NAME,
SPERSO.PERS_NR

FROM AKOPF

LEFT JOIN
    SPERSO ON SPERSO.NR = AKOPF.VERKAEUFER

WHERE
    AKOPF.AUFTRAGSNUMMER = 427759;