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

select v.vstdate, v.hn, v.vn, concat(pt.pname,pt.fname,”  “,pt.lname) as ptname, v.pdx ,d.icode ,d.name,
d1.name
from vn_stat v
left outer join opitemrece o on o.vn = v.vn
left outer join patient pt on pt.hn = v.hn
left outer join doctor d1 on d1.code=v.dx_doctor
left outer join drugitems d on d.icode=o.icode
where v.vstdate between ‘2012-10-01’ and ‘2012-10-30’
and v.pdx not like ‘z%’ and    d.icode is null
group by v.vn
order by v.vstdate