1. SELECT mahasiswa.nim, mahasiswa.nama, nilai.nim,nilai.nilai
FROM mahasiswa JOIN nilai
ON nilai.nim=mahasiswa.NIM;
2. SELECT matakuliah.nama_MK, mahasiswa.nama, nilai.nilai
from mahasiswa
INNER JOIN nilai
ON mahasiswa.nim=nilai.nim
INNER JOIN matakuliah
ON nilai.kode_MK = matakuliah.kode_MK
0 komentar:
Posting Komentar