Task 11 - 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",
SABRZWECK.MATCHCODE


FROM ATOUR

JOIN
    ATASEND ON ATOUR.NR = ATASEND.TOURNR
JOIN
    ASDGABRECHNUNG ASDGAB ON ATASEND.NR = ASDGAB.ATAID
JOIN
    SWAEHRUNG SW ON SW.ID = ATOUR.PREISVORGABEWAEHRUNGIDGS
JOIN
    atafrachtzahler ON ATASEND.NR = atafrachtzahler.TAID
JOIN
    SABRZWECK ON SABRZWECK.ID = atafrachtzahler.ABRZWECK

WHERE
    ATOUR.TOURNUMMER IN (425608, 446595, 385378);