如何sql为什么报错呀

Question

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

Answer 1

table A 没有CF_ID ，低级错误。