mysql左联查询子表最新内容实例

主表：intd
子表：gengxin
子表保存主表事项的每日进展

// 左联查询某个时间段数据，带子表最新的更新，且最新为空也显示（未提交任何更新时）
select * 
from intd
left join
gengxin
on intd.id = gengxin.intd_id
where (date(intd.xm12) between '2018-04-22' and '2018-05-31') 
and gengxin.time in (select max(time) from gengxin group by intd_id) 
or gengxin.time is null order by xm4 desc

// 左联查询某个时间段数据，带子表最新的更新
select * 
from intd
left join
gengxin
on intd.id = gengxin.intd_id
where (date(xm12) between '2018-04-22' and '2018-05-31') 
and gengxin.time in (select max(time) from gengxin group by intd_id) 
order by xm4 desc