Untitled

SELECT DISTINCT CD.CDNo, CD.Name
FROM CD
INNER JOIN Recording ON CD.CDNo = Recording.CDNo
WHERE Recording.Orchestra = 'Chicago Symphony Orchestra';