ประมาณ...
select o.vstdate,o.vn,s.smoking_type_name,d.drinking_type_name from opdscreen o
left outer join smoking_type s on s.smoking_type_id=o.smoking_type_id
left outer join drinking_type d on d.drinking_type_id=o.drinking_type_id
where vn="'+DBPipeline['vn']+'"