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