chronicfu
select o1.vn,pt.cid,o2.seq_id,o2.nhso_seq_id,o2.pcu_person_id,c1.* ,o3.bw ,o3.height,o3.waist,o3.vstdate,o3.bps,o3.bpd from clinicmember_cormobidity_screen c1 ,ovst o1,ovst_seq o2 ,opdscreen o3,patient pt where c1.vn = o1.vn and o1.vn = o2.vn and o1.vn = o3.vn and pt.hn = o1.hn and c1.vn in (xxxxxxxxxx')