以下sql:
SELECT
RCV.FNC_APLY_CUST_ID AS custId,
mgmt.num AS num,
AGRM.AGRM_PARM as agrmParm
FROM COFP.T_FNC_APLY_RCV rcv ,
(SELECT FNC_APLY_ID,SUM(NBRPCKS) num FROM COFP.T_WH_WHRECPT_MGMT_CMDTY WHERE STAT = '1' GROUP BY FNC_APLY_ID) mgmt
LEFT JOIN T_COMMD_BSN_AGRM agrm ON rcv.AGRM_ID = AGRM.AGRM_ID
where rcv.stat = '1' and mgmt.FNC_APLY_ID = rcv.FNC_APLY_ID
在mysql8上会报错:Unknown column 'rcv.AGRM_ID' in 'on clause',请问为什么?应该怎么改写呢?mysql8中表关联可以像上面这样把逗号和join混用吗?