Advertisement
luthfy13

Untitled

May 16th, 2024
853
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.56 KB | None | 0 0
  1. SELECT
  2.     vwPindahHbInternal.*,
  3.     trx_surat_pindah_hb_internal.*,
  4.     mst_perihal_surat.perihal_surat
  5. FROM
  6.     trx_surat_pindah_hb_internal
  7.     INNER JOIN trx_surat ON trx_surat_pindah_hb_internal.no_surat = trx_surat.no_surat
  8.     INNER JOIN mst_perihal_surat ON trx_surat.id_perihal = mst_perihal_surat.id_perihal
  9.     INNER JOIN vwPindahHbInternal ON vwPindahHbInternal.id_permintaan = trx_surat_pindah_hb_internal.id_permintaan
  10. WHERE
  11.     vwPindahHbInternal.sts_permintaan = '6'
  12.     AND vwPindahHbInternal.id_profil = '222033'
  13.     AND getIdUnitSurat ( trx_surat.no_surat ) = id_fakultas
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement