IBANK - PROJECT

insert into CBTBMKT060 (pgmCde,prdTyp,accTypCde,mktCde,rptCde,recSts,createBy,createDte)
select a.pgmCde,c.prdTyp,c.accTypCde,NULL as mktcde, '530-000-001/63' as rptcde,'A' as recsts,'Auto' as createby,getdate() as createDte
from CBTBMKT040 as a
inner join CBTBMKT041 as b on a.pgmCde = b.pgmCde and b.recSts ='A' and b.prdSeq = 1
inner join CBTBMKT042 as c on b.pgmCde = c.pgmCde and b.prdTyp= c.prdTyp and c.recSts='A'
left join CBTBMKT060 as d on d.rptCde ='530-000-001/63' and d.pgmCde= c.pgmCde and d.prdTyp= c.prdTyp and d.accTypCde= c.accTypCde and d.recSts='A'
where a.mrtaFlg = 1
and a.prjSts='A'
and a.recSts ='A'
and d.pgmCde is null
group by a.pgmCde,c.prdTyp,c.accTypCde