Outer Join

Terdapat 3 macam Outer Join:

1. Left Outer Join
2. Right Outer Join
3. Full Outer Join

Syntax:

SELECT * FROM albums LEFT JOIN artists ON albums.artist_id = artists.id;