SELECT * FROM tmp_proses_d20an_biner_tunggal  A INNER JOIN tmp_proses_d20an_biner_tunggal B
ON A.nim = B.nim AND A.masa = B.MASA AND A.KODE_TEMPAT_UJIAN != B.KODE_TEMPAT_UJIAN AND
A.KODE_JENIS_D20AN = B.KODE_JENIS_D20AN AND A.cetakan_ke = B.cetakan_ke AND A.HARI = B.HARI
WHERE A.MASA = '20182'  AND
   (A.KODE_MTK_1 = (B.kode_mtk_1 OR B.kode_mtk_2 OR B.kode_mtk_3 OR B.kode_mtk_4 OR B.kode_mtk_5 )
OR A.KODE_MTK_2 = (B.kode_mtk_1 OR B.kode_mtk_2 OR B.kode_mtk_3 OR B.kode_mtk_4 OR B.kode_mtk_5 )
OR A.KODE_MTK_3 = (B.kode_mtk_1 OR B.kode_mtk_2 OR B.kode_mtk_3 OR B.kode_mtk_4 OR B.kode_mtk_5 )
OR A.KODE_MTK_4 = (B.kode_mtk_1 OR B.kode_mtk_2 OR B.kode_mtk_3 OR B.kode_mtk_4 OR B.kode_mtk_5 )
OR A.KODE_MTK_5 = (B.kode_mtk_1 OR B.kode_mtk_2 OR B.kode_mtk_3 OR B.kode_mtk_4 OR B.kode_mtk_5 ))
GROUP BY  A.KODE_TEMPAT_UJIAN
ORDER BY A.NAMA_MAHASISWA;