รบกวนช่วยเพิ่มเวลามารับบริการให้หน่อยครับ

[chaiya_chaiyo]

select v.*,concat(p.pname,p.fname,"  ",p.lname) as ptname
from vn_stat v,ovst o, patient p
where v.vn = o.vn and v.vstdate between "2006-01-01" and "2006-01-31" and o.hn = p.hn
and v.pcode = "A1" 
order by vn

[chaiya_chaiyo]

ช่วยด้วยคร๊าบบบบ

[nph2006]

select v.*,concat(p.pname,p.fname,"  ",p.lname) as ptname, o.vsttime
from vn_stat v,ovst o, patient p
where v.vn = o.vn and v.vstdate between "2006-01-01" and "2006-01-31" and o.hn = p.hn
and v.pcode = "A1" 
order by vn

[BMS MA Team]

select v.*,o.vsttime,concat(p.pname,p.fname,"  ",p.lname) as ptname
from vn_stat v,ovst o, patient p
where v.vn = o.vn and v.vstdate between "2009-01-01" and "2009-01-01" and o.hn = p.hn
and v.pcode = "A1" 
order by vn