mysql: select artist.name from artist inner join album on artist.id=album.artist_id inner join song on album.id=song.album_id where song.title='So Cruel'; +------+ | name | +------+ | U2 | +------+