จะเพิ่มคำสั่งผลของแลป Cretinine ในรายการอย่างไรครับ...

[bkl]

จะเพิ่มผลของแลป Cretinine ในรายการอย่างไรครับ...

select pt.hn,concat(pt.pname,pt.fname," ",pt.lname) as fullname,se.name,ov.age_y,pt.birthday,pt.informaddr,opd.bw,ov.pdx,ov.vstdate,
ov.dx0,ov.dx1,ov.dx2,ov.dx3,ov.dx4,ov.dx5,ov.income
from vn_stat ov ,patient pt ,ovst ovst,sex se,opdscreen opd
where ov.vn=ovst.vn and pt.hn=ov.hn and ov.sex=se.code and ov.vstdate between "2011-01-01" and "2011-01-31" and ov.hn=pt.hn and opd.vn=ov.vn
and ov.sex="1"
and ov.age_y>= 0
and ov.age_y<= 200
and ( (ov.pdx = "N180")
or (ov.dx0 = "N180") or (ov.dx1 = "N180") or (ov.dx2 = "N180") or (ov.dx3 = "N180")
or (ov.dx4 = "N180") or (ov.dx5 = "N180") or (ov.pdx = "N19") or (ov.dx0 = "N19")
or (ov.dx1 = "N19") or (ov.dx2 = "N19") or (ov.dx3 = "N19") or (ov.dx4 = "N19")
or (ov.dx5 = "N19") or (ov.pdx = "I120") or (ov.dx0 = "I120") or (ov.dx1 = "I120")
or (ov.dx2 = "I120") or (ov.dx3 = "I120") or (ov.dx4 = "I120") or (ov.dx5 = "I120")
or (ov.pdx = "E112") or (ov.dx0 = "E112") or (ov.dx1 = "E112") or (ov.dx2 = "E112")
or (ov.dx3 = "E112") or (ov.dx4 = "E112") or (ov.dx5 = "E112") or (ov.pdx = "M10")
or (ov.dx0 = "M10") or (ov.dx1 = "M10") or (ov.dx2 = "M10") or (ov.dx3 = "M10")
or (ov.dx4 = "M10") or (ov.dx5 = "M10"))
order by ov.vstdate desc

[pop_hosxp]

วาง variable ลงไป 1 ตัว แล้วใช้คำสั่งนี้วางลงไปครับ

value:=getsqlstringdata('select l2.lab_order_result '+
' from lab_head l1 '+
' left outer join lab_order l2 on l2.lab_order_number = l1.lab_order_number '+
' where l1.vn="'+dbpipeline['vn']+'" '+
' and l2.lab_items_code = 'xxx' ')

แก้ไขตรง xxx ให้เป็น lab_items_code ของ creatinine ด้วยครับ