โรงพยาบาลจอมพระ

select pt.*,ov.*
from an_stat ov ,patient pt ,ipt ovst
where ov.an=ovst.an and ov.regdate between “2013-10-01” and “2014-06-25” and ov.hn=pt.hn
and ov.age_y>= 0
and ov.age_y<= 200
and ov.pcode in (
“A1″
,”AA”
,”AB”
,”AC”
,”AD”
,”AE”
,”AF”
,”AG”
,”AI”
,”AJ”
,”AK”
,”UB”
,”UC”
)
and ( (ov.pdx like “e%”)
)

0

0