....................................................................
SELECT p.cid,concat(p.pname,p.fname,' ',p.lname) as person_name ,p.sex,p.birthdate,concat(p.age_y,".",p.age_m,".",p.age_d) as age_person ,vsc.village_school_class_name,vs1.school_name,vs.school_room_no FROM person p
LEFT OUTER JOIN village_student vs ON p.person_id = vs.person_id
LEFT OUTER JOIN village_school_class vsc ON vs.village_school_class_id = vsc.village_school_class_id
LEFT OUTER JOIN village_school vs1 ON vs.village_school_id = vs1.village_school_id
WHERE p.sex='2' AND vs.discharge='N' AND vs.village_school_class_id='8'
..................................................................
ดาว์นโหลดเอกสารที่เกี่ยวข้อง
Cr. ไฟล์เอกสารดาว์นโหลด รพ.สต.บ้านโพธิ์
