mysql关联表查询最新的数据

 

mysql关联表查询最新的数据

 

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