SQL Statement that was executed:
SELECT "C"."CARRNAME" AS "Carrier Name", "P"."CONNID" AS "Flight", "P"."CITYFROM" AS "From", "P"."CITYTO" AS "To", "A"."FLDATE" AS "Date", "P"."DEPTIME" AS "Departs", "A"."PRICE" AS "Price", "A"."CURRENCY" AS "Curr" FROM "TEST_CARRIERS" "C", "TEST_PLANFLI" "P", "TEST_ACTFLI" "A" WHERE ((("C"."MANDT" = "P"."MANDT") AND ("C"."CARRID" = "P"."CARRID")) AND (("P"."MANDT" = "A"."MANDT") AND ("P"."CARRID" = "A"."CARRID"))) AND ("P"."CONNID" = "A"."CONNID") ORDER BY "C"."CARRNAME" ASC, "P"."CITYFROM" ASC, "P"."CITYTO" ASC, "A"."FLDATE" ASC, "P"."DEPTIME" ASC

Result set:

Carrier Name Flight From To Date Departs Price Curr
ABC Airlines 1000 Frankfurt Paris 19991230 081000 200 DEM
ABC Airlines 1234 Paris Frankfurt 19991230 175500 500 DEM
ABC Airlines 1234 Paris Frankfurt 19991231 175500 300 DEM
XYZ Flights 0007 Frankfurt Madrid 19990505 093500 110 USD
XYZ Flights 0006 Madrid Moscow 19990606 163000 100 USD