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)
이담에 서브쿼리가 에러라고 뜨는데요
머가 문제인가요
|