MYSQL/WITH 별칭1 AS (), 별칭2 AS () SELECT구문 (1) 썸네일형 리스트형 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, .. 이전 1 다음