SELECT
    AC0561.TRGT_KEY_2
FROM
    AC_T_TRGT_KEY_WK AC0561
    INNER JOIN
        (SELECT
             ZM0321.WORK_PARAM_SETTE_VALUE
         FROM
             ZM_M_WORK_PARAM_KNRI ZM0321
         WHERE
             ZM0321.WORK_PARAM_ID       = :WORK_PARAM_ID
         AND ZM0321.WORK_PARAM_TSTAYMD <= :OPEDATE
         AND ZM0321.WORK_PARAM_TENDYMD >= :OPEDATE
         AND ZM0321.MK_FLG              = '0'
        ) ZM0321
    ON
        ZM0321.WORK_PARAM_SETTE_VALUE = TRIM(AC0561.TRGT_KEY_WK_USE_KINO_CD)
WHERE
    AC0561.MK_FLG = '0'