Advertisement
fxlik

EDOM - jadwal pengisian modified

Sep 15th, 2020
1,090
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.28 KB | None | 0 0
  1. SELECT fakultas.fakultas, prodi.prodi, jadwal_pengisian.tanggal_mulai, jadwal_pengisian.tanggal_selesai FROM prodi
  2. JOIN fakultas on fakultas.id = prodi.fakultas_id
  3. JOIN jadwal_pengisian on prodi.id = jadwal_pengisian.prodi_id
  4. WHERE jadwal_pengisian.periode_id = 365
  5. ORDER BY fakultas_id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement