Inner Join

Inner Join
SELECT mhs.nama NAMA, SUM(pst.nilai) NILAI
FROM mahasiswa mhs
INNER JOIN peserta pst
ON mhs.nim = pst.nim
group by mhs.nama

Outer Join
SELECT mhs.nama NAMA, SUM(pst.nilai) NILAI
FROM mahasiswa mhs , peserta pst
WHERE mhs.nim = pst.nim
GROUP BY mhs.nama;

Left Outer Join
SELECT mhs.nama NAMA, SUM(pst.nilai) NILAI
FROM mahasiswa mhs LEFT OUTER JOIN peserta pst
ON mhs.nim = pst.nim
GROUP BY mhs.nama;

Cross Join
SELECT mhs.nama NAMA, pst.nilai NILAI, pst.nim NIM
FROM mahasiswa mhs, peserta pst

• Tweet
• Share
• Share
• Share
• Share

Sign up here with your email