Enfant 0-18 ans pour une année
select * from tracking_infant where timestampdiff(year,dob,'2017-01-01')<=18 and year(death_date)=2017 and id_patient in(select id from patient where linked_to_id_patient=0)
select * from tracking_infant where timestampdiff(year,dob,'2017-01-01')<=18 and year(death_date)=2017 and id_patient in(select id from patient where linked_to_id_patient=0)
Comments