select d1.*,v1.*,o1.*,s.*,t.blobtext,t.blobtext2,pe.image1,ic.name as diag_name0
from doctor_order_print d1
left outer join vn_stat v1 on v1.vn=d1.vn
left outer join ovst o1 on o1.vn=d1.vn
left outer join opdscreen s on s.vn = d1.vn
left outer join pe_image pe on pe.vn=d1.vn
left outer join tempreport t on t.name=d1.vn and t.reportname="DOCTOR-FORM"
left outer join icd101 ic on ic.code = v1.dx0
-----------------------------------------------------------------------------------------------
left outer join smoking_type s1 on s1.smoking_type_id=d1.smoking_type_id
left outer join drinking_type d on d.drinking_type_id=o.drinking_type_id
-----------------------------------------------------------------------------------------------
where d1.vn="531129152924" and d1.print_server="MANOI-NOTEBOOK"
เอา smoking_type กับ drinking_type มา join แล้ว error ครับ รบกวนช่วยแก้ไขให้หน่อยนะครับ ขอบคุณครับ
... แก้ไขเป็น
--------------------------------------------------------
left outer join smoking_type s1 on s1.smoking_type_id = s.smoking_type_id
left outer join drinking_type d on d.drinking_type_id = s.drinking_type_id
--------------------------------------------------------
... :D ...