Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
sql_query
SELECT concat(CONCAT(CONCAT(concat(CONCAT(concat(a.KD_PROPINSI, a.KD_DATI2), a.KD_KECAMATAN), a.KD_KELURAHAN), a.KD_BLOK), a.NO_URUT), a.KD_JNS_OP) AS nop,
a.STATUS_PEMBAYARAN_SPPT AS st_lunas, b.SUBJEK_PAJAK_ID AS nik, c.NM_WP AS nama
FROM SPPT a, DAT_OBJEK_PAJAK b, DAT_SUBJEK_PAJAK c
WHERE concat(CONCAT(CONCAT(concat(CONCAT(concat(a.KD_PROPINSI, a.KD_DATI2), a.KD_KECAMATAN), a.KD_KELURAHAN), a.KD_BLOK), a.NO_URUT), a.KD_JNS_OP) = concat(CONCAT(CONCAT(concat(CONCAT(concat(b.KD_PROPINSI, b.KD_DATI2), b.KD_KECAMATAN), b.KD_KELURAHAN), b.KD_BLOK), a.NO_URUT), b.KD_JNS_OP)
AND b.SUBJEK_PAJAK_ID=c.SUBJEK_PAJAK_ID
AND EXTRACT(YEAR FROM TO_DATE(a.TGL_TERBIT_SPPT, 'DD-MON-RR')) = 2018;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.