Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- vwPindahHbInternal.*,
- trx_surat_pindah_hb_internal.*,
- mst_perihal_surat.perihal_surat
- FROM
- trx_surat_pindah_hb_internal
- INNER JOIN trx_surat ON trx_surat_pindah_hb_internal.no_surat = trx_surat.no_surat
- INNER JOIN mst_perihal_surat ON trx_surat.id_perihal = mst_perihal_surat.id_perihal
- INNER JOIN vwPindahHbInternal ON vwPindahHbInternal.id_permintaan = trx_surat_pindah_hb_internal.id_permintaan
- WHERE
- vwPindahHbInternal.sts_permintaan = '6'
- AND vwPindahHbInternal.id_profil = '222033'
- AND getIdUnitSurat ( trx_surat.no_surat ) = id_fakultas
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement