Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- tugasguru.tugas, view_detil_siswa.nmSiswa, view_detil_siswa.nisSiswa, tugasguru.kelas, tugasguru.intruksi, tugasguru.tanggaltugas, tugasguru.namaguru, tugasguru.namatugas, tugasguru.kodetugas, tugas.nama_file
- FROM
- view_detil_siswa
- LEFT JOIN tugas
- ON tugas.nis= view_detil_siswa.nisSiswa
- LEFT JOIN tugasguru
- ON view_detil_siswa.nmKelas = tugasguru.kelas AND tugasguru.tugas = tugas.mapel
- WHERE tugas.nis IS NOT NULL AND tugasguru.tugas IS NOT NULL
- SELECT tugasguru.tugas, view_detil_siswa.nmSiswa, view_detil_siswa.nisSiswa, tugasguru.kelas, tugasguru.intruksi, tugasguru.tanggaltugas, tugasguru.namaguru, tugasguru.namatugas, tugasguru.kodetugas, tugas.nama_file FROM (view_detil_siswa LEFT JOIN tugasguru ON view_detil_siswa.nmKelas = tugasguru.kelas) LEFT JOIN tugas ON tugas.kodetugas = tugasguru.kodetugas
- ORDER BY `tugas`.`nama_file` DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement