CREATE VIEW StarMovies(movieTitle, movieYear, movieStarName) AS
SELECT title, year, movieStarName
FROM Movies, StarsIn
WHERE movieTitle = title AND movieYear = year;
(Edited: 2019-11-20) CREATE VIEW StarMovies(title, year, movieStarName) AS SELECT title, year, starName FROM Movies, StarsIn WHERE title=movieTitle AND year=movieYear;(Edited: 2019-11-20)
CREATE VIEW StarMovies(title, year, starName) AS
SELECT title, year, starName
FROM StarsIn
WHERE StarsIn.title=title AND StarsIn.year = year;
(Edited: 2019-11-20) CREATE VIEW StarMovies(title, year, movieStarName) AS SELECT title, year, MovieStar.name FROM Movies, StarsIn, MovieStar WHERE StarsIn.movie = Movies.title AND StarsIn.year = Movies.year AND StarsIn.starName = MovieStar.name(Edited: 2019-11-20)
CREATE VIEW StarMovies(title, year, movieStarName) AS SELECT movieTitle, movieYear, starName FROM StarsIn WHERE true;(Edited: 2019-11-20)
CREATE VIEW StarMovies(title, year, movieStarName) AS (SELECT * FROM StarsIn);(Edited: 2019-11-20)
CREATE VIEW StarMovies(title, year, movieStarName) AS
SELECT title, year, movieStarName
FROM (Movies NATURAL JOIN StarsIn)
CREATE VIEW StarMovies(title, year, movieStarName) AS
SELECT title, year, starName
FROM Movies, StarsIn
WHERE title = Movies.title AND year = Movies.year;
(Edited: 2019-11-20) CREATE VIEW StarMovies(title, year, movieStarName) AS SELECT title, year, name FROM Movies, StarsIn WHERE title=movieTitle AND name=starName(Edited: 2019-11-20)