CREATE VIEW EditedTab(url, transcriber, email, modified) AS (SELECT Tablature.url, Tablature.transcriber, email, modified FROM Tablature, Transcriber WHERE Tablature.transcriber = Transcriber.transcriber); View created. Elapsed: 00:00:00.10 SELECT * FROM EditedTab; URL -------------------------------------------------------------------------------- TRANSCRIBER -------------------------------------------------------------------------------- EMAIL -------------------------------------------------------------------------------- MODIFIED --------- ftp://www.olga.net/d/deftones/mx.tab Bill Smith bill@smith.com 14-JUN-98 URL -------------------------------------------------------------------------------- TRANSCRIBER -------------------------------------------------------------------------------- EMAIL -------------------------------------------------------------------------------- MODIFIED --------- ftp://www.olga.net/f/filter/take_a_picture.tab Bobby Jones bobby@jones.com 10-OCT-98 URL -------------------------------------------------------------------------------- TRANSCRIBER -------------------------------------------------------------------------------- EMAIL -------------------------------------------------------------------------------- MODIFIED --------- ftp://www.olga.net/d/deftones/headup.tab Kate Digrigorio kate@dg.com 03-JAN-98 URL -------------------------------------------------------------------------------- TRANSCRIBER -------------------------------------------------------------------------------- EMAIL -------------------------------------------------------------------------------- MODIFIED --------- ftp://www.olga.net/p/papa_roach/last_resort.tab Sarah Kitchell sarah@kitchell.com 12-MAR-00 URL -------------------------------------------------------------------------------- TRANSCRIBER -------------------------------------------------------------------------------- EMAIL -------------------------------------------------------------------------------- MODIFIED --------- ftp://www.olga.net/f/far/savory.tab Bobby Jones bobby@jones.com 26-NOV-97 CREATE VIEW OnLabel(Artist, ArtistURL, RecordCompany, CompanyURL) AS (SELECT A.name, A.homepage, RC.name, RC.homepage FROM (SELECT name, homepage FROM Artist) A, (SELECT name, homepage FROM RecordCompany) RC, ProducedBy WHERE A.name=ProducedBy.groupName AND RC.name=ProducedBy.companyName); View created. Elapsed: 00:00:00.08 SELECT * FROM OnLabel; ARTIST -------------------------------------------------------------------------------- ARTISTURL -------------------------------------------------------------------------------- RECORDCOMPANY -------------------------------------------------------------------------------- COMPANYURL -------------------------------------------------------------------------------- Far www.infectious.com/far Epic, Immortal www.immortalrecords.com ARTIST -------------------------------------------------------------------------------- ARTISTURL -------------------------------------------------------------------------------- RECORDCOMPANY -------------------------------------------------------------------------------- COMPANYURL -------------------------------------------------------------------------------- Deftones www.deftones.com Maverick http://www.maverickrc.com ARTIST -------------------------------------------------------------------------------- ARTISTURL -------------------------------------------------------------------------------- RECORDCOMPANY -------------------------------------------------------------------------------- COMPANYURL -------------------------------------------------------------------------------- Papa Roach www.paparoach.com Dreamworks http://www.dreamworksrecords.com ARTIST -------------------------------------------------------------------------------- ARTISTURL -------------------------------------------------------------------------------- RECORDCOMPANY -------------------------------------------------------------------------------- COMPANYURL -------------------------------------------------------------------------------- WillHaven www.willhaven.com Revelation Records http://revelationrecords.com ARTIST -------------------------------------------------------------------------------- ARTISTURL -------------------------------------------------------------------------------- RECORDCOMPANY -------------------------------------------------------------------------------- COMPANYURL -------------------------------------------------------------------------------- Filter www.officialfilter.com Revelation Records http://revelationrecords.com ARTIST -------------------------------------------------------------------------------- ARTISTURL -------------------------------------------------------------------------------- RECORDCOMPANY -------------------------------------------------------------------------------- COMPANYURL -------------------------------------------------------------------------------- Incubus www.enjoyincubus.com Epic, Immortal www.immortalrecords.com 6 rows selected. Elapsed: 00:00:00.03