In the alliance data in the aggregation database, is the oneworld alliance meant to have Malasya Airlines spelt that way, when in the air_routes table it is spelt Malaysia Airlines,
The same for KLM in skyteam, but in air_routes it is KLM Royal Dutch Airways.
The join from air_routes.airline.name to air_alliances.airline, fails for these airlines.
Is this the reason for the comment in the question
Names are distinct, i.e. Delta != Delta Air Lines