select * from assessData ad
LEFT JOIN assessComplete ac ON ac.pid = ad.id
AND ac.addTime = ( SELECT MAX ( addTime ) FROM assessComplete ac2 WHERE ac2.pid = ad.id )
left join khDamInfo kd on ac.id=kd.pid
where kd.deviceName='莫力庙大街(创业大道-柳荫路)'
重复数据 时间筛选
最新推荐文章于 2024-06-09 18:24:15 发布