select left(patient_code,8) as site, patient_code, dpa, ddr from tracking_pregnancy left join patient on patient.id=id_patient_mother where (dpa>now() or ddr > '2017-01-27') and patient_code is not null group by patient_code
select left(patient_code,8) as site, patient_code, dpa, ddr from tracking_pregnancy left join patient on patient.id=id_patient_mother where (dpa>now() or ddr > '2017-01-27') and patient_code is not null group by patient_code
Comments