select D.* from CCFORM_DEBIT_ALL D left JOIN (select sm_fid, to_char(wmsys.wm_concat(sm_calrec)) SM_CALREC from SM_CALLOG group by sm_fid) A ON A.CF_ID = D.CF_ID
