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

select o.hn,o.main_dep,o.vstdate,v.vstdate,v.vn,v.hn,v.pdx,v.dx0,v.dx1,v.dx2,v.dx3,v.dx4,v.dx5
from ovst o
left outer join vn_stat v on v.hn=o.hn and v.vstdate=o.vstdate
where (o.vstdate between ‘2014-09-01’ and ‘2014-09-31’)
and pdx like ‘%u%’

————————————————————————————————————————-

select o.hn,o.main_dep,o.vstdate,v.vstdate,v.vn,v.hn,v.pdx,v.dx0,v.dx1,v.dx2,v.dx3,v.dx4,v.dx5
from ovst o
left outer join vn_stat v on v.hn=o.hn and v.vstdate=o.vstdate
where (o.vstdate between ‘2013-12-01’ and ‘2014-01-31’)
and (
(v.pdx like ‘%u%’ and v.dx0 not like ‘%m%’ and v.dx1 not like ‘%m%’ and
v.dx2 not like ‘%m%’ and v.dx3 not like ‘%m%’ and v.dx4 not like ‘%m%’ and v.dx5 not like ‘%m%’) or
(v.dx0 like ‘%u%’ and v.pdx not like ‘%m%’ and v.dx1 not like ‘%m%’ and
v.dx2 not like ‘%m%’ and v.dx3 not like ‘%m%’ and v.dx4 not like ‘%m%’ and v.dx5 not like ‘%m%’) or
(v.dx1 like ‘%u%’ and v.pdx not like ‘%m%’ and v.dx0 not like ‘%m%’ and
v.dx2 not like ‘%m%’ and v.dx3 not like ‘%m%’ and v.dx4 not like ‘%m%’ and v.dx5 not like ‘%m%’) or
(v.dx2 like ‘%u%’ and v.pdx not like ‘%m%’ and v.dx0 not like ‘%m%’ and
v.dx1 not like ‘%m%’ and v.dx3 not like ‘%m%’ and v.dx4 not like ‘%m%’ and v.dx5 not like ‘%m%’) or
(v.dx3 like ‘%u%’ and v.pdx not like ‘%m%’ and v.dx0 not like ‘%m%’ and
v.dx2 not like ‘%m%’ and v.dx1 not like ‘%m%’ and v.dx4 not like ‘%m%’ and v.dx5 not like ‘%m%’) or
(v.dx4 like ‘%u%’ and v.pdx not like ‘%m%’ and v.dx0 not like ‘%m%’ and
v.dx2 not like ‘%m%’ and v.dx3 not like ‘%m%’ and v.dx1 not like ‘%m%’ and v.dx5 not like ‘%m%’) or
(v.dx5 like ‘%u%’ and v.pdx not like ‘%m%’ and v.dx0 not like ‘%m%’ and
v.dx2 not like ‘%m%’ and v.dx3 not like ‘%m%’ and v.dx4 not like ‘%m%’ and v.dx1 not like ‘%m%’))

0

0