Code a condition to only join rows that have a matching artist_id in the other table.

Make sure to pick ON artist.artist_id followed by = and then album, ., artist_id.