SQL Portal

SELECT
ATASEND.NR AS "Primary key",
ATASEND.TANUMMER AS "TO Number",
SL.ISOALPHA2CODE AS "Sender Country",
ASENDUNG.ABS_ORT1 AS "Sender City",
ASENDUNG.ABS_PLZ AS "Sender Post Code",
ATASEND.VONLADEDATUM AS "Loading Target Date",
SLA.ISOALPHA2CODE AS "Receiver Country",
ASENDUNG.EMP_ORT1 AS "Receiver City",
ASENDUNG.EMP_PLZ AS "Receiver Post Code",
ATASEND.VONLIEFERDATUM AS "Delivery Target Date",
sverkaufsart.BEZEICHNUNG AS "Type",
ASENDUNG.GEWICHTF AS "Weight (kg)",
CASE
    WHEN ASENDUNG.GEFAHRGUT = 1 THEN 'Contains Dangerous Goods'
    WHEN ASENDUNG.GEFAHRGUT = 0 THEN 'Does not contain Dangerous Goods'
     ELSE 'Unknown'
END AS "Dangerous Goods Status",
CASE
    WHEN ASENDUNG.CHECK0 = 1 THEN 'Yes'
    WHEN ASENDUNG.CHECK0 = 0 THEN 'No'
    ELSE 'Unknown'
END AS "Temperature Controlled"

FROM ATASEND

LEFT JOIN
    SLAND SL ON SL.LAND = ATASEND.VON_LAND
LEFT JOIN
    SLAND SLA ON SLA.LAND = ATASEND.NACH_LAND
LEFT JOIN
    ASENDUNG ON ASENDUNG.SENDUNGID = ATASEND.ASENDUNGID
LEFT JOIN
    ATOUR ON ATOUR.NR = ATASEND.TOURNR
LEFT JOIN
    SKUNDEN ON SKUNDEN.NR = ATOUR.UNTERNEHMER
LEFT JOIN
    sverkaufsart ON sverkaufsart.ID = ASENDUNG.VERKAUFSARTID
LEFT JOIN
    sfzgtyp ON sfzgtyp.nr = ATASEND.FAHRZEUGTYP
WHERE
    ATASEND.TANUMMER = 886733;
--    ATASEND.VONLADEDATUM >= TO_DATE('01-01-2020', 'dd-mm-yyyy')
--    AND
--    ATASEND.VONLADEDATUM <= TO_DATE('01-03-2020', 'dd-mm-yyyy')
--    AND
----    ATASEND.LOCKSTATUS = 0
----    AND
--    ATOUR.TOURNUMMER IS NULL
--    AND
--    SKUNDEN.NAME1 IS NULL
--    AND
--    sverkaufsart.BEZEICHNUNG = 'FTL';