连表得出相同条件,提交时间比较大的那条。
select m.id,m.number,max_w.max_finished_on from t_hj_info m
INNER JOIN
(SELECT package_id, MAX(finished_on) AS max_finished_on
FROM t_wsf_work
where 1=1 and is_return !=-1
GROUP BY package_id) max_w ON m.id = max_w.package_id
where 1=1