SELECT CD_TITLE, GENRE, LENGTH, YEAR, ARTIST_NAME
FROM CD NATURAL join (SELECT CD_ID, ARTIST_NAME
                      FROM CD_ARTIST  NATURAL join ARTIST
                      WHERE CD_ID = '4C275F7653A219D172A7F8AD7DA43967')
WHERE CD_ID = '4C275F7653A219D172A7F8AD7DA43967';