SELECT B.isinNm, A.remCnt, A.estiAmt, A.itemCd, C.mrtgGrade
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'

---------------------------------

위쿼리에서 on B.isinNo = A.itemCd inner JOIN

Error: 'select' 키워드 근처의 구문이 잘못되었습니다. (State:37000, Native Code: 9C)
Error: ')' 근처의 구문이 잘못되었습니다. (State:37000, Native Code: 66)

이담에 서브쿼리가 에러라고 뜨는데요

머가 문제인가요