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

select r.hn,concat(p.pname,p.fname,’ ‘,p.lname) as ptname, r.*,
o.vstdate,o.vsttime,t.name as pttype_name
from rcpt_arrear r
left outer join ovst o on o.vn=r.vn
left outer join patient p on p.hn=r.hn
left outer join pttype t on t.pttype = o.pttype
where r.arrear_date between ‘2015-09-01’ and ‘2015-09-30’
and r.paid in (‘Y’,’N’)
order by r.arrear_id