Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select
- pa.tahun,
- pa.term,
- h.nama as hari,
- k.id as id_kelas,
- jk.waktu_mulai,
- jk.waktu_selesai,
- 'dummy' as ruangan,
- mk.id as id_mata_kuliah,
- mk.kode_mata_kuliah,
- mk.nama as nama_mata_kuliah,
- mk.jumlah_sks,
- mk.silabus,
- mk.flag_spesial,
- mk.semester,
- pj.id as id_staf_pengajar,
- pj.nomor_induk,
- pj.nomor_induk_nasional,
- pj.nama as nama_staf_pengajar,
- pj.nomor_serdos,
- pj.gelar_depan,
- pj.gelar_belakang,
- pj.tahun_lulus,
- pj.tanggal_masuk
- from tran_jadwal_kelas jk
- inner join tran_kelas k on k.id = jk.id_kelas
- inner join tmst_mata_kuliah mk on mk.id = k.id_mata_kuliah
- inner join tran_pengajar_kelas pk on pk.id_kelas = k.id
- inner join tmst_staf_pengajar pj on pj.id = pk.id_pengajar
- inner join tref_hari h on h.id = jk.id_hari
- inner join tref_periode_akademik pa on pa.id = k.id_periode_akademik
- inner join tmst_institusi ins on ins.id = pj.id_institusi
- inner join tran_pengguna_sistem ps on ps.id = pj.nomor_induk
- inner join tmst_pengguna p on p.id = ps.id_pengguna
- where p.id = 47
- order by h.id, jk.waktu_mulai;
- select
- pa.tahun,
- pa.term,
- h.nama as hari,
- k.id as id_kelas,
- jk.waktu_mulai,
- jk.waktu_selesai,
- 'dummy' as ruangan,
- mk.id as id_mata_kuliah,
- mk.kode_mata_kuliah,
- mk.nama as nama_mata_kuliah,
- mk.jumlah_sks,
- mk.silabus,
- mk.flag_spesial,
- mk.semester,
- pj.id as id_staf_pengajar,
- pj.nomor_induk,
- pj.nomor_induk_nasional,
- pj.nama as nama_staf_pengajar,
- pj.nomor_serdos,
- pj.gelar_depan,
- pj.gelar_belakang,
- pj.tahun_lulus,
- pj.tanggal_masuk
- from tran_jadwal_kelas jk
- inner join tran_kelas k on jk.id_kelas = k.id
- inner join tmst_mata_kuliah mk on k.id_mata_kuliah = mk.id
- inner join tran_pengajar_kelas pk on pk.id_kelas = k.id
- inner join tmst_staf_pengajar pj on pk.id_pengajar = pj.id
- inner join tref_hari h on jk.id_hari = h.id
- inner join tran_irs i on i.id_kelas = k.id
- inner join tran_riwayat_akademik ra on ra.id = i.id_riwayat_akademik
- inner join tref_periode_akademik pa on pa.id = ra.id_periode_akademik
- inner join tmst_mahasiswa_institusi mi on ra.id_mahasiswa_institusi = mi.id_mahasiswa
- inner join tmst_mahasiswa mh on mi.id_mahasiswa = mh.id
- inner join tmst_institusi ins on ins.id = mi.id_institusi
- inner join tran_pengguna_sistem ps on ps.id = mh.nomor_induk
- inner join tmst_pengguna p on p.id = ps.id_pengguna
- where p.id = 1442
- order by h.id, jk.waktu_mulai;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement