left join on between
Ta的回复 :SELECT DATE_ADD(t1.etta_depart_date,CAST(MIN(eag.aging_time)/24 AS BIGINT)) AS expect_arrive_time FROM a表 t1 LEFT JOIN ( SELECT DISTINCT mileage_from,mileage_to,aging_time FROM b表 ) eag ON t1.etta_rate_mileage between eag.mileage_from and eag.mileage_to 不好意思 sql重新整理一下发出来了