查询失败: Unknown column 'S.CATE_CODE' in 'on clause'
sql=SELECT C.DIS_MODE,C.NAME AS BRAND_NAME,P.* FROM (PROD P, CATEGORY C, PROD_CATE PC) LEFT JOIN SERIES_ODR S ON (P.SERIES=S.SERIES AND C.CATE_CODE=S.CATE_CODE), PROD_PARA PPP WHERE P.PK_PROD=PC.PK_PROD AND PC.PK_CATEGORY=C.PK_CATEGORY AND P.VALID_FLAG='Y' AND C.VALID_FLAG='Y' AND LEFT(C.CATE_CODE,6)='001001' AND P.PK_PROD = PPP.PK_PROD AND PPP.PK_CATEPARA=62 AND PPP.VALUE>=0 AND PPP.VALUE<=300 GROUP BY P.PK_PROD ORDER BY C.NAME,S.ODR DESC,P.MODEL