G. Saiz - N. Wolovick
Existen varios operadores del estilo del join que son provistos por bases de datos comerciales.
SELECT starName FROM Actor1996 WHERE studioName="Paramount";donde hay dos vistas definidas
CREATE VIEW Actor1996 AS SELECT starName, studioName FROM MoviesOf1996 NATURAL JOIN starsIn;
CREATE VIEW MovieOf1996 AS SELECT * FROM Movie WHERE year=1996; y los esquemas sonMovie(title,year,length,inColor,studioName,producerC#)
StarsIn(title,year,starName)