2024-12-26 17:39:24
 DATA KRS : => 
			SELECT krs.nim_mhs, krs.id AS pos_khs, krs.id_mk, st.kode_mk, st.mata_kuliah, st.sks, st.sem, krs.id_kelas AS nama_kelas, krs.tahun_smt AS tahun_krs, 
				tr_jadwal_kul.hari, tr_jadwal_kul.jam_kuliah, tr_jadwal_kul.ruang_kuliah, m_guru.nama, tr_jadwal_kul.uas_dosen
			FROM ((tr_nilai_mhs AS krs 
				INNER JOIN ref_std_krs AS st ON krs.id_mk = st.id_mk) 
				LEFT JOIN tr_jadwal_kul ON krs.kelas_id = tr_jadwal_kul.ordid) LEFT JOIN m_guru ON tr_jadwal_kul.id_dosen = m_guru.nip
			WHERE (((krs.tahun_smt)='20241') AND ((krs.id_mhs)=55714))
			ORDER BY tr_jadwal_kul.hari, tr_jadwal_kul.jam_kuliah