ช่วยแก้ไข SQL นี้ให้แสดงข้อมูลที่อยู่ของผู้ป่วยแยกหมู่บ้านและตำบลให้หน่อยครับ

[doitao]

select v.hn,v.vstdate,c.number,concat(p.pname,p.fname,"  ",p.lname) as ptname,
lb.lab_items_normal_value_ref as normal,lb.lab_order_result as LDL
 from vn_stat  v
left outer join lab_head lh on lh.vn=v.vn
left outer join opdscreen o on o.vn=v.vn
left outer join patient p on p.hn=v.hn
left outer join lab_order lb on lb.lab_order_number=lh.lab_order_number
left outer join clinicmember c on c.hn=v.hn
where  v.vstdate between '2010-10-01' and '2011-10-31'
and c.clinic =(select sys_value from sys_var where sys_name='dm_clinic_code')
and lb.lab_order_result <=100 and lb.lab_items_code in ("160")
order by v.vstdate