with사용 예

WITH M30A0206 AS
(
    SELECT QA_TRK_ACT_CODE_EXPLAIN1, QA_TRK_ACT_CODE FROM VI_M00_M30A0206 WHERE OPER_FLAG='L'
)
 
select
    mtl_no,
    CROL600.QA_TRK_CODE1,    
    CROL600.QA_TRK_ACT_CODE11,
    CROL600.QA_TRK_ACT_CODE12,
    CROL600.QA_TRK_ACT_CODE13,
   
    M30A0207.QA_TRK_CODE_EXPLAIN QA_TRK_CODE1_EXPLANI,
    (SELECT QA_TRK_ACT_CODE_EXPLAIN1 FROM M30A0206 WHERE QA_TRK_ACT_CODE = CROL600.QA_TRK_ACT_CODE11) QA_TRK_ACT_CODE11_EXPLAIN,
    (SELECT QA_TRK_ACT_CODE_EXPLAIN1 FROM M30A0206 WHERE QA_TRK_ACT_CODE = CROL600.QA_TRK_ACT_CODE12) QA_TRK_ACT_CODE12_EXPLAIN,
    (SELECT QA_TRK_ACT_CODE_EXPLAIN1 FROM M30A0206 WHERE QA_TRK_ACT_CODE = CROL600.QA_TRK_ACT_CODE13) QA_TRK_ACT_CODE13_EXPLAIN

from
TB_M22_CROL600 CROL600,
VI_M00_M30A0207 M30A0207

WHERE
CROL600.QA_TRK_CODE1 = M30A0207.QA_TRK_CODE AND
mtl_no='CBA0346'
;