Pasted

select distinct patient.patient_code from tracking_pregnancy
left join patient on patient.id = tracking_pregnancy.id_patient_mother
left join tracking_children on tracking_children.id_patient_mother = tracking_pregnancy.id_patient_mother
left join tracking_infant on tracking_infant.id_patient = tracking_children.id_patient_child
left join tracking_motherbasicinfo on tracking_motherbasicinfo.id_patient = tracking_pregnancy.id_patient_mother
where (tracking_pregnancy.actual_delivery_date>='2014-10-01' and tracking_pregnancy.actual_delivery_date <'2015-09-30')
or (tracking_pregnancy.dpa>='2014-10-01' and tracking_pregnancy.dpa <'2016-06-30')
or (tracking_pregnancy.ddr>='2014-02-01' and tracking_pregnancy.ddr <'2015-09-30')
or (tracking_infant.dob >= '2014-10-01' and tracking_infant.dob < '2015-09-30')
or (tracking_children.dob >= '2014-10-01' and tracking_children.dob < '2015-09-30')
or (tracking_motherbasicinfo.PTME_date >= '2014-10-01' and tracking_motherbasicinfo.PTME_date < '2015-09-30')