존넌님 감사합니다.. 하지만 다음과 같이 수정해도 에러네용을
같네요..
수고스럽지만 다시 한번 봐주세용 ㅠㅠ
SELECT B.isinNm, A.remCnt, A.estiAmt, A.itemCd, X.name
FROM
db_bd_loan..BD_MRTG_MASTER As A join
db_bg_securities..BG_SECURITIES_BASIS AS B
on B.isinNo = A.itemCd inner JOIN
(select C.isinNo, SUBSTRING(MAX(Convert(char(10), C.recordDt)+
Convert(char(3),C.mrtgGrade)),11,3) as name
from db_bg_securities..BG_MRTG_GRADE as C join
db_bd_loan..BD_MRTG_MASTER AS D
on C.isinNo = D.itemCd
where D.loanAcntNo = '1013142103046'
group by C.isinNo)as X
on X.isinNo = A.itemCd
WHERE A.loanAcntNo ='1013142103046'
|