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 |