select concat(p.pname,p.fname,' ',p.lname) as ptname,  t.name as pttype_name,  v.*  from vn_stat v  left outer join patient p on p.hn=v.hn  left outer join pttype t on t.pttype=v.pttype  where v.vstdate between '2010-08-04'  and '2010-08-20' and   (v.rcpt_money>0)  order by v.vn

แบบนี้พอได้บ่