Select the album table's title under the alias album.
album
title
Make sure to type album.title AS album.
album.title AS album