如下sql为什么报错呀

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

最佳答案

左连接表(子查询表A) 无 CF_ID字段,或为其别名的字段