Question

SQL 未明确定义列

insert into AGL89M12
select
NVL(A31BRCH,D.A89BRCH)
from AGL31M00 e
FULL OUTER JOIN

(SELECT A89GLNO,A89BRCH,A89CCYC, ABS(AMNT) A89AMNT,(CASE WHEN AMNT >=0 THEN 'DR' ELSE 'CR' END ) A89DRCR FROM
(SELECT A89GLNO,A89BRCH,A89CCYC,SUM(CASE WHEN A89DRCR = 'DR' THEN A89AMNT ELSE (-1) * A89AMNT END) AMNT FROM AGL89M01 GROUP BY A89GLNO,A89BRCH,A89CCYC) A)

D ON e.A31BRCH = D.A89BRCH
AND e.A31CCYC = D.A89CCYC
AND TRIM(CASE WHEN e.A31CUCD =' ' THEN e.A31ACIT ELSE e.A31CUCD END) = TRIM(D.A89GLNO)
LEFT JOIN (select refno,
(case
when bchtype = '2' then
parent
else
refno
end )sbch
from TABCHM01) A ON e.A31BRCH = A.REFNO
;
commit;

外边一起执行FULL OUTER JOIN 下select 没问题 执行最外层的 就有问题 报未明确定义列

Answer 1

有字段名重复了，检查一下
取字段的时候，最好加上表名
如：NVL(A31BRCH,D.A89BRCH)-->NVL(e.A31BRCH,D.A89BRCH)

Answer 2

表连接的过程中公共字段名了（两表之间列名相同）