ลอง โค๊ด: ActionScriptselect o.hn,concat(p.pname,p.fname," ",p.lname) as patient ,o.vstdate,o.clinic,o.nextdate from oapp o ,patient p where o.hn=p.hn and o.vstdate ="2012-04-18" order by o.vn