SQL สแกนลายนิ้วมือ
DateTime : 1468-08-15 16:01:57
Post By : tharatip
IP Address : 125.25.164.36
Post By : tharatip
IP Address : 125.25.164.36
select ft.template,pt.hn,pt.cid,concat(pt.pname,pt.fname,' ',pt.lname) as ptname,pt.informaddr,
pt.addrpart,pt.moopart,pt.tmbpart,pt.amppart,pt.chwpart
from finger_template ft
left outer join patient pt on pt.hn=ft.hn
group by ft.hn
order by pt.hn
