SQL & PL/SQL

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?