SELECT ORIGINAIRPORT.`flightnum`,
       ORIGINAIRPORT.`origin airport`,
       DESTINATOINAIRPORT.`destination airport`

FROM
        (SELECT DISTINCT flight.flightnum,
                        flight.`originairportid`,
                        airport.airportdescription AS "Origin Airport"
        FROM   flight
               INNER JOIN airport
                       ON flight.`originairportid` = airport.airportid
        WHERE  airport.airportdescription LIKE BINARY "%ak%")

AS ORIGINAIRPORT

JOIN

        (SELECT DISTINCT flight.flightnum,
                             flight.`destairportid`,
                             airport.airportdescription AS "Destination Airport"
             FROM   flight
                    INNER JOIN airport
                            ON flight.`destairportid` = airport.airportid
             WHERE  airport.airportdescription LIKE BINARY "%ak%")

AS DESTINATOINAIRPORT

ON ORIGINAIRPORT.flightnum = DESTINATOINAIRPORT.flightnum