Inner Join
SELECT * FROM albums AS al JOIN artists AS ar ON al.artist_id = ar.artists_id;
Berikut merupakan diagram venn dari Inner Join.