Task 18 - SQL

SELECT
    SK.NAME1 AS "Customer Name",
    FAKTURANR AS "Invoice Number",
    FAKTURADATUM AS "Invoice Date",
    SK.EMAIL AS "E-mail for sending of invoices",
--    MMANDANTEN.NAME1
    FAKTURADATUM
FROM
    AFAKTURA
JOIN
    SKUNDEN SK ON SK.NR = AFAKTURA.FAKTURAPARTNER
JOIN
    MMANDANTEN ON MMANDANTEN.NR = AFAKTURA.MANDANT
WHERE
    MMANDANTEN.NR = 1