jeniferfleurant

# Enfants testés PCR

Sep 2nd, 2016
301
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.35 KB | None | 0 0
  1. select count(*) from (
  2. select * from (select id_patient as id from tracking_infant where  eid_pcr_program=1
  3. ) a
  4. union  
  5. select id_patient as id from testing_specimen
  6. union  select id_patient as id from testing_result
  7. union select id_patient as id from testing_mereenfant
  8.   ) r
  9. where id not in (select id from patient where linked_to_id_patient!=0)
Advertisement
Add Comment
Please, Sign In to add comment