select t.addressid,if(c.clinic="015","โรคหอบหืด(Ashma)","โรคปอดอุดกั้นเรื้อรัง(COPD)") as clinicopd ,c.hn,CONCAT(pa.pname,pa.fname," ",pa.lname) as paName ,pa.hn,pa.addrpart,pa.moopart,t.full_name from clinicmember c
left OUTER JOIN patient pa ON c.hn=pa.hn
LEFT OUTER JOIN thaiaddress t ON CONCAT(pa.chwpart,pa.amppart,pa.tmbpart) =t.addressid
where c.clinic in("015","016") AND pa.tmbpart in("01","02","03","04","05")
ไม่มีความคิดเห็น:
แสดงความคิดเห็น