คำสั่งแสดงข้อมูลที่อยู่ ในโปรแกรม HOSxP (บันทึก)

 concat(pt.addrpart," หมู่ที่ ",pt.moopart," ต.",t3.name," อ.",t2.name," จ.",t1.name) as fulladdressname

left outer join thaiaddress t1 on t1.chwpart=pt.chwpart and t1.amppart="00" and
t1.tmbpart="00"
left outer join thaiaddress t2 on t2.chwpart=pt.chwpart and
t2.amppart=pt.amppart and t2.tmbpart="00"
left outer join thaiaddress t3 on t3.chwpart=pt.chwpart and
t3.amppart=pt.amppart and t3.tmbpart=pt.tmbpart

Share on Google Plus

About Mamakio

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.