SongAlbumRecording
Moonglow Benny Goodman Story, The 5188
   "Moonglow 480
   "Les Brown Vol. 4 604
   "Benny Goodman, The Small Groups 672
   "Dancing in the Dark 1030
   "Sentimental Journey - 30s and 40s 3326
   "Swing Era, Music of 1936-1937 5130
   "Sings the Ultimate American Songbook, Vol. 1 6334
   "Blue Light 7661
   "But Beautiful 9339
   "Songs You Love to Remember 11664
   "Back Bay Shuffle 11747

SELECT PCS.Name AS "Song", ALB.Name AS "Album", REC.ID AS "Recording" FROM Recordings REC JOIN Pieces PCS ON PCS.ID = REC.Piece_FK JOIN Albums ALB ON ALB.ID = REC.ALBUM_FK WHERE PCS. Name = "Moonglow"