SELECT
    KK0531.CREDIT_KOKAN_CD,
    KK0531.CRECARD_COMP_NM
FROM
    KK_M_CRECARD_COMP KK0531
WHERE
    KK0531.CRECARD_JIGYO_CD = '2'
AND KK0531.CRECARD_COMP_TSTAYMD <= ?
AND KK0531.CRECARD_COMP_TENDYMD >= ?
AND (KK0531.CRECARD_COMP_CD, KK0531.CRECARD_JIGYO_CD, KK0531.RSV_APLY_YMD || KK0531.GENE_ADD_DTM ) =
    (SELECT
         KK0531_GENE.CRECARD_COMP_CD, KK0531_GENE.CRECARD_JIGYO_CD, MAX(KK0531_GENE.RSV_APLY_YMD || KK0531_GENE.GENE_ADD_DTM)
     FROM
         KK_M_CRECARD_COMP KK0531_GENE
     WHERE
         KK0531_GENE.CRECARD_COMP_CD  = KK0531.CRECARD_COMP_CD
     AND KK0531_GENE.CRECARD_JIGYO_CD = KK0531.CRECARD_JIGYO_CD
     AND KK0531_GENE.RSV_APLY_YMD <= ?
     AND KK0531_GENE.MK_FLG = '0'
     GROUP BY KK0531_GENE.CRECARD_COMP_CD, KK0531_GENE.CRECARD_JIGYO_CD)