Advertisement
Guest User

Untitled

a guest
Jul 7th, 2013
41
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.38 KB | None | 0 0
  1. SELECT DISTINCT(o1.person_id)
  2. FROM obs o1
  3. WHERE concept_id = 134  #birthday CALL IS effective
  4. AND value_coded = 144
  5. AND voided = 0
  6. AND o1.obs_datetime > (
  7.         SELECT MAX(obs_datetime)
  8.         FROM obs o2
  9.         WHERE concept_id = 107 #person entered birthday wrong 3 times
  10.         AND value_coded = 1
  11.         AND voided = 0
  12.         AND o2.person_id = o1.person_id
  13.     );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement