mysql left join on使用两个或多个字段关联查询 解决查询如下 解决 left join on 通过两个或多个字段才可以关联到一条数据 ON o.to_id=r.to_id AND o.from_id=r.from_id 查询如下 SELECT o.id,r.to_id, r.from_id,r.distance FROM my_order AS o LEFT JOIN 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, );