Write a condition to match artist and album rows only if the artist's id matches the album's artist_id.
artist
album
id
artist_id
Make sure to type = album.artist_id.
= album.artist_id