10
« เมื่อ: ตุลาคม 31, 2012, 14:02:36 PM »
ผมลองทำแล้วมันขึ้นทุกตัวครับ
select o.vn,o.hn,concat(p.pname,p.fname," ",p.lname) as pt_name,p.cid,o.vstdate,v.age_y,v.pttypeno
,if(op.icode like "1%",concat(d.name,d.strength," ",d.units),nd.name) as drugname
,op.icode,op.qty,op.unitprice,op.sum_price,op.income,op.paidst
,if(op.paidst="01" or op.paidst="02",sum_price,null) as reim_amount
,if(op.paidst="03",sum_price,null) as not_reim_amount
,if(op.icode like "1%",if(op.paidst=03,"àºÔ¡äÁèä´é","àºÔ¡ä´é"),concat("ÃËÑÊ ",nd.billcode)) as reim_status
,if(op.income="03",if(d.drugaccount ='','¤èÒÂҹ͡ºÑ­ªÕÂÒËÅÑ¡áË觪ҵÔ','¤èÒÂÒ㹺ѭªÕÂÒËÅÑ¡áË觪ҵÔ'),i.name)as check_drugtype
,concat("***",i.name,"***") as income_name,o.vsttime,p1.name,concat(v.hospmain," ",h.hosptype,h.name) as hospname
,concat(p.addrpart,"ËÁÙè ",p.moopart," ",p.road," ",t.full_name) as fulladdressname
,concat(pc.name," , ",pa.name) as pcname,shortlist,d1.name as doctor_name,pdx,v.pttype,v.pttype,p.chwpart,p1.pcode,v.item_money,v.hospmain
,pn.presc_reason
from ovst o
join patient p on p.hn=o.hn
join vn_stat v on v.vn=o.vn
LEFT OUter Join thaiaddress t ON t.addressid=v.aid
join opitemrece op on op.vn=o.vn
join income i on i.income=op.income
join income_report2 i2 on i2.group_id=i.group2
left outer join drugitems d on d.icode=op.icode
left outer join nondrugitems nd on nd.icode=op.icode
left outer join pttype p1 on p1.pttype=v.pttype
left outer join hospcode h on h.hospcode=v.hospmain
left outer join paidst pa on pa.paidst=p1.paidst
left outer join pcode pc on pc.code =p1.pcode
left outer join drugusage du on du.drugusage =op.drugusage
left outer join doctor d1 on d1.code =o.doctor
join ovst_presc_ned pn on pn.vn =o.vn
where o.vn="551025140054"
order by income_name,i2.group_id,check_drugtype, op.item_no