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,
	);