任何人都有此错误的经历吗?我不太使用Oracle,在此查询中我是否遗漏了一些非常明显的内容?
我想这与我使用别名的方式有关吗?
SELECT T1.acc_CDE,T3.CUST_DESC,T1.PROD_DESC,FROM SCHEMA.TABLE1 T1
LEFT JOIN (SELECT CUST_NO,MIN(CUST_CDE) AS CUSTOMER_CODE
FROM SCHEMA.TABLE2
GROUP BY CUST_NO) SCHEMA.TABLE2 T2
ON T1.CUST_NO = T2.CUST_NO
LEFT JOIN SCHEMA.TABLE3 T3
ON T2.CUST_CDE = T3.CUST_CDE
GROUP BY T1.acc_CDE,T3.CUST_DESC