SQLSkript V2.0
--History
--18.10.2024 Georgi Horozov

stat:Name=Gopet_ClientsAndAddresses
stat:HelpContext_Dlg=01012267632132312024
stat:Modules=carlo
stat:CheckSum=E7BF7721421162024
ALLROWS

in:var_LoadingDateActual:timespace:Actual loading date


out:Truck number:Truck number:atour.LKWKZ::count:1
out:Trailer number:Trailer number:atour.ANHAENGERKZ::count:2
out:GOPET LOGISTICS EOOD as Sender:GOPET LOGISTICS EOOD as Sender:SK.NAME1::count:3
out:Loading date when Sender is GOPET LOGISTICS EOOD:Loading date when Sender is GOPET LOGISTICS EOOD:CASE WHEN SK.KUNDENNR = 23164813 THEN LADEDATUMSTARTIST END::count:4
out:GOPET LOGISTICS EOOD as Receiver:GOPET LOGISTICS EOOD as Receiver:SKU.NAME1::count:5
out:Unloading date when Receiver is GOPET LOGISTICS EOOD:Unloading date when Receiver is GOPET LOGISTICS EOOD:CASE WHEN SKU.KUNDENNR = 23164813 THEN LIEFERDATUMENDEIST END::count:6
out:Carrier name:Carrier name:S.NAME1::count:7
out:Tour number:Tour number:ATOUR.TOURNUMMER::count:8



*SELECT*
FROM ATOUR
JOIN ATASEND ON ATOUR.NR = ATASEND.TOURNR
JOIN ASENDUNG ON ASENDUNG.SENDUNGID = ATASEND.ASENDUNGID
JOIN SKUNDEN S ON S.NR = ATOUR.UNTERNEHMER
JOIN SKUNDEN SK ON SK.NR = ASENDUNG.ABSNR
JOIN SKUNDEN SKU ON SKU.NR = ASENDUNG.EMPFNR

WHERE LADEDATUMENDEIST >= :var_LoadingDateActual 
AND LADEDATUMENDEIST <= :var_LoadingDateActual
AND (SK.KUNDENNR = 23164813 OR SKU.KUNDENNR = 23164813);