SELECT
TOURNUMMER AS "Tour number",
VON_LAND AS "Sender country",
VON_ORT1 AS "Sender City",
VON_PLZ AS "Sender POST code",
ASE.ORIGBISLADEDATUMZEIT,
BISLADEDATUM


FROM
    ATOUR
JOIN
    ATASEND ON ATOUR.NR = ATASEND.TOURNR
JOIN
    ASENDUNG ASE ON ASE.SENDUNGID = ATASEND.ASENDUNGID

WHERE
    TOURNUMMER = 439315