jeniferfleurant

infant under 5 weighted last 3 months

Mar 31st, 2016
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.27 KB | None | 0 0
  1. select patient_code, first_name, last_name, dob from tracking_infant left join patient on patient.id = id_patient
  2. where timestampdiff(year,dob,now())<5 and
  3. id_patient in (select id_patient from tracking_followup
  4. where weight > 0 and timestampdiff(month, date,now())<=3
  5. )
Add Comment
Please, Sign In to add comment