BMS-HOSxP Community
HOSxP => แจ้งปัญหา / ขอความช่วยเหลือ => ข้อความที่เริ่มโดย: chaiya_chaiyo ที่ สิงหาคม 20, 2009, 13:12:48 PM
-
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
-
ช่วยด้วยคร๊าบบบบ
-
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
-
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