mysql关联表查询最新的数据

 

mysql关联表查询最新的数据

 

?

1 2 3 4 5 6 7 8 9

select it.name,ns.id,it.id childId,it.id_card idCard,it.card_type cardType,it.birthday,ns.guardian guardian,ns.mother_phone motherPhone,nf.guide_time updateTime,(select station from station where id = ns.station_id) station              ,ss.name staff,ss.phone staffPhone,ns.direct,ns.direct_num guideNum,TIMESTAMPDIFF(MONTH,it.birthday,CURDATE()) month         from infant it left join              (SELECT * FROM nurture_station WHERE id IN (SELECT MAX(id) FROM nurture_station  GROUP BY child_id)) ns              on it.id = ns.child_id            left join station_staff ss on ns.staff_id=ss.id            left join (SELECT * FROM nurture_family WHERE id IN (SELECT MAX(id) FROM nurture_family  GROUP BY nurture_id)) nf                      on ns.id = nf.nurture_id             where 1=1