SHOW:
|
|
- or go back to the newest paste.
| 1 | select | |
| 2 | 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 | |
| 3 | ||
| 4 | from | |
| 5 | view_detil_siswa | |
| 6 | left join tugas | |
| 7 | ON tugas.nis= view_detil_siswa.nisSiswa | |
| 8 | LEFT JOIN tugasguru | |
| 9 | ON view_detil_siswa.nmKelas = tugasguru.kelas and tugasguru.tugas = tugas.mapel | |
| 10 | where tugas.nis is not null and tugasguru.tugas is not null | |
| 11 | ||
| 12 | ||
| 13 | 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 | |
| 14 | ORDER BY `tugas`.`nama_file` DESC |
