Mybatis MySql Left Join

agnusdei·2023년 7월 5일
0
post-custom-banner
<!-- 관리자 조회 -->
<select id="UserSelectList" parameterType="VO" resultType="VO">
    /* VO.UserSelectList */
    <![CDATA[       
            SELECT	 
                     A.SEQ							seq
                    ,A.ID							id
                    ,A.NAME							name
                    ,B.C_CD_NM						position

              FROM	t_ad_user A
   LEFT OUTER JOIN	t_code B  
                ON	A.POSITION = B.C_CD
               AND	B.USE_YN = 'Y'

             WHERE	A.USE_YN = 'Y'
               AND	A.SEQ IN (${userSeq})
      ]]>         
</select>```
post-custom-banner

0개의 댓글