Write a condition to join rows only if the artist.artist_id equals album.artist_id.

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