Task 12 - SQL

SELECT DISTINCT
TOURNUMMER AS "Tour number",
LKWKZ AS "Truck number",
ANHAENGERKZ AS "Trailer number",
PREISVORGABEBETRAGGS AS "Tour price",
ASDGAB.BETRAG AS "Amount",
SW.ISOWAEHRUNGSCODE AS "Currency tour amount",
SABRZWECK.BEZEICHNUNG AS "Calculation purpose"



FROM ATOUR

LEFT JOIN
    ATASEND ON ATOUR.NR = ATASEND.TOURNR
LEFT JOIN
    ASDGABRECHNUNG ASDGAB ON ATASEND.NR = ASDGAB.ATAID
LEFT JOIN
    SWAEHRUNG SW ON SW.ID = ATOUR.PREISVORGABEWAEHRUNGIDGS
LEFT JOIN
    atafrachtzahler ON Atour.NR = atafrachtzahler.tournr
LEFT JOIN
    SABRZWECK ON SABRZWECK.ID = atafrachtzahler.ABRZWECK
WHERE
    ATOUR.TOURNUMMER IN (425608);