IBANK - PROJECT

โครงการที่ต้องเช็คเพิ่มเติม
334-1
336-1
187

query ไว้ดู data ค่ะ
select distinct b.pgmCdeDesc,c.accTypCde,c.refin,c.refin_min,c.earlyclose,c.earlyclose_min,c.earlyclose_other
from CBTBMKT060 as a
left join CBTBMKT040 as b on a.pgmCde = b.pgmCde and b.recSts='A'
left join CBTBMKT042 as c on a.pgmCde= c.pgmCde and c.recSts='A'
where rptCde ='001-893-011/63' and a.recSts='A' and prjSts ='A'
order by b.pgmCdeDesc,c.accTypCde