refer ไม่ลงค่า cause
select r.vn,r.refer_date,r.refer_cause,r.refer_number,r.doctor,d.name,r.refer_point,r.department,r.refer_time,r.hn,r.pdx,r.depcode,r.spclty
from referout r
left join doctor d on d.code=r.doctor
where r.refer_date between ‘2014-10-01’ and ‘2014-10-31’ and ( r.refer_cause is null or r.refer_cause=” )
ความเห็นล่าสุด