Tugas SQL Tanggal 17 November 2014

SELECT mahasiswa1.nim, mahasiswa1.nama, nilai3.nim, nilai3.nilai
FROM mahasiswa1 JOIN nilai3
ON mahasiswa1.nim = nilai3.nim

SELECT matakuliah1.nama_MK, mahasiswa1.nama, nilai3.nilai

FROM mahasiswa1
JOIN nilai3 ON mahasiswa1.nim = nilai3.nim
JOIN matakuliah1 ON matakuliah1.kode_MK = nilai3.kode_MK