select p.person_id,p.pname,p.fname,p.lname,vss.age_y age
,address(p.patient_hn) address
,s.school_name school
,vsc.village_school_class_name class
,vs.school_room_no room
,vss.screen_date
,cast(vss.body_weight as signed) bw,cast(vss.height as signed) height
,l1.name nutrition_level
,l2.name height_level
,l3.name bmi_level
from village_student vs
left join person p on p.person_id=vs.person_id
left join village_school_class vsc on vsc.village_school_class_id=vs.village_school_class_id
left join village_school s on s.village_school_id=vs.village_school_id
left join village_student_screen vss on vss.village_student_id=vs.village_student_id
left join nutrition_level l1 on l1.nutrition_level=vss.nutrition_level
left join height_level l2 on l2.height_level=vss.height_level
left join bmi_level l3 on l3.bmi_level=vss.bmi_level
order by p.person_id,vss.screen_date desc
หัวข้อ: ขอความช่วยเหลือ สร้างคิวรี่ บัญชี5 งานเชิงรุก (อ่าน 3600 ครั้ง)