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