SELECT voc_a.acptdd, voc_a.acptseq, (SELECT cdnm FROM com.zbcmcode WHERE cdgrupid = 'C0001' and cdid = voc_a.acpttypecd) as acpttype, voc_c.deptnm, voc_c.deptcd, voc_c.empnm, voc_c.empid, voc_a.acpttitl, voc_b.clntnm, voc_c.rgstseq FROM crm.cuvhacpi voc_a, crm.cuvhhtmi voc_b, crm.cuvhdepi voc_c WHERE voc_a.acptdd = voc_b.acptdd and voc_a.acptseq = voc_b.acptseq and voc_a.acptdd = voc_c.acptdd and voc_a.acptseq = voc_c.acptseq and voc_a.instcd = '{?instcd}' and voc_a.acptkindlrgcd = 'P' and voc_a.cnclyn = 'N' and voc_a.acptdd >= '{?srchacptdd1}' and voc_a.acptdd <= '{?srchacptdd2}' ORDER BY voc_c.deptcd, voc_c.empnm, voc_a.acptdd desc