Your problem is not the left outer join. Your syntax is wrong.
Try the following:
<pre>
INSERT
INTO H000.H0COO_TRAN_ALC_HIS
( CLNT_ID
, ACCT_NBR
, PST_DT
, ITM_SEQ_NBR
, ALLC_SEQ_NBR
, CREAT_TS
, ACCTG_CDE
, ALLC_AMT
, CREAT_USR_ID
, UPDT_USR_ID
, UPDT_TS
, ALLC_ORGNR
, ALLC_TYP_CDE
, SEL_AAC_NM
, SEL_AAC_TYP
)
SELECT OLD_ROW.CLNT_ID
, OLD_ROW.ACCT_NBR
, OLD_ROW.PST_DT
, OLD_ROW.ITM_SEQ_NBR
, OLD_ROW.CREAT_TS
, OLD_ROW.ALLC_SEQ_NBR
, OLD_ROW.ACCTG_CDE
, OLD_ROW.ALLC_AMT
, OLD_ROW.CREAT_USR_ID
, OLD_ROW.UPDT_USR_ID
, OLD_ROW.UPDT_TS
, OLD_ROW.ALLC_ORGNR
, OLD_ROW.ALLC_TYP_CDE
, TA.SEL_AAC_NM
, TA.SEL_AAC_TYP
FROM H000.H0COO_TRANS_CALLC OLD_ROW
LEFT OUTER JOIN H000.H0COR_TRANS_AAC TA
ON (OLD_ROW.CLNT_ID = TA.CLNT_ID
AND OLD_ROW.ACCT_NBR = TA.ACCT_NBR
AND OLD_ROW.PST_DT = TA.PST_DT
AND OLD_ROW.ITM_SEQ_NBR = TA.ITM_SEQ_NBR)
;
</pre>
This should do the job.
Discuss This Question: