main query IF: SELECT * FROM main, coverage, maincoverage, subject, mainsubject
WHERE main.MainID=1266
AND coverage.coverageID=maincoverage.coverageID
AND main.MainID=maincoverage.MainID
AND main.MainID=mainsubject.MainID
AND subject.SubjectID=mainsubject.SubjectID
ORDER BY Name, subject_name
Access: Publicly available resource
Description: Provides discographic information for commercially-released show music recordings starting with those captured on early cylinders in the late 19th century and continuing through recent compact disc productions of the early 21st century. Lists original cast recordings of American shows produced for the stage, screen, and television, and foreign stage shows and motion pictures that played in the U.S., as well as commercial recordings of later albums and medleys from shows, individual show tunes performed by members of original, revival, and studio casts, records of composers performing their own show songs, and selected additional recordings of related interest.
Coverage: 1900 & earlier to present
Subject(s): Music, Film & Performing Arts Publicly Available Resources
Related Databases
International Index to Music Periodicals
Oxford Music Online
Related Links
American Memory
Return to Top
|
|