java List lstCode = getExecutor().selectList("SELECT_CODE", param); param.put("CODELST", lstCode); mesExecutor.selectDataTable("SELECT_List ", param)); /* SELECT_CODE */ SELECT GRP_CD AS CODE , KEY_VAL_1 AS ID FROM TEMP WHERE 1=1 /* SELECT_List */ WITH TMP AS ( SELECT #{item.CODE} CD, #{item.ID} ID FROM DUAL ) SELECT * FROM SysTMP A , TMP B WHERE 1=1 AND A.CD = B.CD AND A.ID = B.ID