SELECT

d.flight_no   , b.arrival_flight

FROM
jtl_booking_transfer_details                    AS      b
LEFT  JOIN jtl_flight_info                      AS      d
       ON  (d.flight_no      b.arrival_flight),

jtl_booking_master                                     a,
jtl_hotels                                             c,
jtl_airlines                                           e


WHERE

a.voucher_number                             =        b.voucher_number             AND
b.hotel_id                                   =        c.hotel_id                   AND
e.airline_code                               =        d.airline_code

SELECT
d.flight_no   , b.arrival_flight

FROM
jtl_booking_transfer_details b
LEFT JOIN jtl_flight_info d
   ON  d.flight_no = b.arrival_flight
LEFT JOIN  jtl_booking_master a
   ON a.voucher_number = b.voucher_number
LEFT JOIN jtl_hotels c
   ON b.hotel_id = c.hotel_id
LEFT JOIN jtl_airlines  e
   ON  e.airline_code = d.airline_code