75
« เมื่อ: พฤศจิกายน 09, 2011, 11:08:55 AM »
ลองใช้คำสั่งชุดนี้ดูนะค่ะ
select p.cid,concat(p.pname,p.fname," ",p.lname) as ptname
,p.mother_name,p.birthdate,p.age_y,p.age_m,p.current_age ,p.cid,h.address,h.road,v.village_moo,
v.village_name,t.full_name as full_address_name,pv.vaccine_name,l.vaccine_date,l.vaccine_note
from person p
left outer join house h on h.house_id = p.house_id
left outer join village v on v.village_id = p.village_id
left outer join thaiaddress t on t.addressid = v.address_id
left outer join person_vaccine_list l on l.person_id=p.person_id
left outer join person_vaccine pv on pv.person_vaccine_id=l.person_vaccine_id
where v.village_id="'ใส่รหัสชุมชน'" and p.age_y between "0" and "5" and trim(p.cid)<>""
order by p.cid