SELECT
o.id,r.to_id, r.from_id,r.distance
FROM
my_order AS o
LEFTJOIN my_route AS r ON o.to_id=r.to_id AND o.from_id=r.from_id
WHERE
o.id IN(15939,15938,15937,);
mysql left join on使用两个或多个字段关联查询解决查询如下解决left join on 通过两个或多个字段才可以关联到一条数据ON concat( o.to_id, o.from_id )= concat( r.to_id, r.from_id )查询如下SELECT o.id,r.to_id, r.from_id,r.distanceFROM my_order AS o LEFT JOIN my_route AS r ON concat( o.to_id, o.from_