WITH 별칭1 AS(), 별칭2 AS() SELECT * FROM

->  편집해서 오른쪽 정렬로 볼것 !

/*master.getModelList*/
WITH SUBSPRODGRP AS (
						SELECT SUBS_PRODGRP_CD,
                        	   SUBS_PRODGRP_NM,
                               CORP_CD,
                               PR_CMPT_APPL_YN
                         FROM  XSBMT_SUBS_PRODGRP_MST
                        WHERE  CORP_CD = #{corpCd} 
					),
      CLBKCGRP AS   (
      					SELECT CMN_CD AS CD,
                         	   CMN_CD_DESC_CNTN AS CD_DESC,
                               CORP_CD
                          FROM XSBCM_CODE_CD
                         WHERE CMN_GRP_CD = 'XSBMT_CLBKC_GRP_CD'
                           AND CORP_CD = #{corpCd}
                           
                     ),
     SALESCOMSGRP1 AS(
     				   SELECT CMN_CD AS CD,
                       		  CMN_CD_DESC_CNTN AS CD_DESC,
                              CORP_CD
                         FROM XSBCM_CODE_CD
                        WHERE CMN_GRP_CD = 'XSBMT_CLBKC_GRP_CD'
                          AND CORP_CD  = #{corpCd}
                      ),
     SALESCOMSGRP2 AS (
     					SELECT CMN_CD AS CD,
                        	   CMN_CD_DESC_CNTN AS CD_DESC,
                               CORP_CD
                          FROM XSBCM_CODE_CD
                         WHERE CMN_GRP_CD = 'XSBMT_SALES_COMS_GRP_CD1'
                           AND CORP_CD = #{corCd}
                       ),
    SVCACTCOMSRPTGRP AS(
    				      SELECT CMN_CD AS CD,
                          	     CMN_CD_DESC_CNTN AS CD_DESC,
                                 CORP_CD
                            FROM XSBCM_CODE_CD
                           WHERE CMN_GRP_CD = 'XSBMT_SVC_COMS_RPT_GRP_CD'
                             AND CORP_CD = #{corpCd}
                       )
                       
       SELECT A.MODEL_CD,
       		  B.SUBS_PRODGRP_CD
         FROM XSBMT_MODEL_MST A
         LEFT JOIN SUBSPRODGRP B
           ON A.SUBS_PRODGRP_CD= B.SUBS_PRODGRP_CD
          AND A.CORP_CD = B.CORP_CD