[Oracle] JOIN 유의점

<select id="selectNewJusoList_rn" parameterType="SearchNEWJUSOVO" resultType="SearchNEWJUSOVO">
 
SELECT
    B.G2_ID, B.BULD_NM, B.BULD_SLNO, M.RN
FROM 
    TL_SPRD_MANAGE M,
    (SELECT 
        DISTINCT G2_ID, BULD_NM, BULD_NM_DC, BULD_MNNM, BULD_SLNO,  RN_CD 
    FROM
        TL_SPBD_BULD    
    AND RN_CD = #{RN_CD}   
    ) B 
WHERE 
    B.RN_CD  = M.RN_CD   
ORDER BY BULD_NM
 
</select>

select 한 결과를 B로 뒀을때, where절에서 비교에 사용할 칼럼을 꼭 select 해줘야 한다!