Hi!
I need to split this row into 2 rows. The key is the flight_leg_id.
SELECT *
FROM favailability a, favailability b
WHERE a.from_city = b.to_city
AND a.to_city = b.from_city
AND a.from_city = 'Zurich'
AND a.service_class = 'Economy'
AND a.fare_type = 'Economy Flex'
AND a.flight_date = '01.10.09'
AND b.from_city = 'London'
AND b.service_class = 'Economy'
AND b.fare_type = 'Economy Flex'
AND b.flight_date = '11.10.09';
FLIGHT_LEG_ID CARRIER_CODE FLIGHT_NO FROM_CITY ORIGIN DEPT_TIME TO_CITY DESTINATION ARR_TIME FLIGHT_DATE AIRCRAFT_TYPE BOOKING_CLASS SERVICE_CLASS NUM_OF_SEATS SEATS_OCC CHECKED_BAG FARE_BASIS FARE_TYPE CURRENCY RT_NET_FARE OW_FARE TAX SURCHARGES FARE_TOTAL FLIGHT_LEG_ID CARRIER_CODE FLIGHT_NO FROM_CITY ORIGIN DEPT_TIME TO_CITY DESTINATION ARR_TIME FLIGHT_DATE AIRCRAFT_TYPE BOOKING_CLASS SERVICE_CLASS NUM_OF_SEATS SEATS_OCC CHECKED_BAG FARE_BASIS FARE_TYPE CURRENCY RT_NET_FARE OW_FARE TAX SURCHARGES FARE_TOTAL
---------------------- ------------ ---------------------- ---------------------------------------------------------------------- ------ --------- ---------------------------------------------------------------------- ----------- -------- ------------------------- ---------------------------------------- ------------- ------------------------------ ---------------------- ---------------------- -------------------- ---------- ------------------------------ -------- ---------------------- ---------------------- ---------------------- ---------------------- ---------------------- ---------------------- ------------ ---------------------- ---------------------------------------------------------------------- ------ --------- ---------------------------------------------------------------------- ----------- -------- ------------------------- ---------------------------------------- ------------- ------------------------------ ---------------------- ---------------------- -------------------- ---------- ------------------------------ -------- ---------------------- ---------------------- ---------------------- ---------------------- ----------------------
3 LX 450 Zurich ZRH 07:00 London LCY 07:35 01.10.09 AVRO RJ100 B Economy 57 20 kg LXB Economy Flex EUR 708 30,01 21,24 759,34 4 LX 345 London LHR 06:00 Zurich ZRH 08:40 11.10.09 Airbus A320 B Economy 72 20 kg LXB Economy Flex EUR 707 30,01 35,24 772,25
1 rows selected
How can I do this?