Yioop - PHP Search Engine

-- Nov 20 In-Class Exercise Thread

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;

(Edited: 2019-11-24)

<br/>CREATE VIEW StarMovies(title, year, movieStarName) AS <br/>SELECT Movies.title, Movies.year, StarsIn.starName <br/>FROM Movies, StarsIn <br/>WHERE title = Movies.title AND year = Movies.year;

-- Nov 20 In-Class Exercise Thread

 Create View StarMovies(title, year, movieStarName) AS
 Select title, year, name
 FROM Movies, StarsIn
 Where title=movieTitle AND name=starNames

Create View StarMovies(title, year, movieStarName) AS Select title, year, name FROM Movies, StarsIn Where title=movieTitle AND name=starNames

-- Nov 20 In-Class Exercise Thread

CREATE VIEW StarMovies(title, year, movieStarName) AS

 	SELECT movieTitle, Year, starName 
 	FROM Movies, StarsIn
       WHERE movieTitle = title AND movieYear = year;

CREATE VIEW StarMovies(title, year, movieStarName) AS SELECT movieTitle, Year, starName FROM Movies, StarsIn WHERE movieTitle = title AND movieYear = year;

-- Nov 20 In-Class Exercise Thread

 CREATE VIEW StarMovies(title, year, starName) AS
              SELECT title, year, starName 
              FROM StarsIn
              WHERE StarsIn.title=title AND StarsIn.year = year;

CREATE VIEW StarMovies(title, year, starName) AS SELECT title, year, starName FROM StarsIn WHERE StarsIn.title=title AND StarsIn.year = year;

-- Nov 20 In-Class Exercise Thread

 CREATE VIEW StarMovies(movieTitle, movieYear, movieStarName) AS 
	SELECT title, year, movieStarName 
	FROM Movies, StarsIn
        WHERE movieTitle = title AND movieYear = year;

CREATE VIEW StarMovies(movieTitle, movieYear, movieStarName) AS SELECT title, year, movieStarName FROM Movies, StarsIn WHERE movieTitle = title AND movieYear = year;

-- Nov 20 In-Class Exercise Thread

CREATE VIEW StarMovies(title, year, movieStarName) AS

SELECT title, year, movieStarName

FROM Movies, StarsIN

WHERE movieTitle = title, year = Movies.year;

CREATE VIEW StarMovies(title, year, movieStarName) AS SELECT title, year, movieStarName FROM Movies, StarsIN WHERE movieTitle = title, year = Movies.year;

-- Nov 20 In-Class Exercise Thread

CREATE VIEW StarMovies(title, year, movieStarName) AS

SELECT title, year, movieStarName

FROM Movies, StarsIn

WHERE movieTitle = title, movieYear = year;

(Edited: 2019-11-25)

CREATE VIEW StarMovies(title, year, movieStarName) AS SELECT title, year, movieStarName FROM Movies, StarsIn WHERE movieTitle = title, movieYear = year;

-- Nov 20 In-Class Exercise Thread

CREATE VIEW StarMovies(title, year, movieStarName) AS

	SELECT title, year, starName

	FROM Movies, StarsIn

	WHERE Movies.title = StarsIn.title AND Movies.year = StarsIn.year;

(Edited: 2019-11-25)

CREATE VIEW StarMovies(title, year, movieStarName) AS SELECT title, year, starName FROM Movies, StarsIn WHERE Movies.title = StarsIn.title AND Movies.year = StarsIn.year;

-- Nov 20 In-Class Exercise Thread

 CREATE VIEW StarMovies(title, year, movieStarName) AS 
	SELECT title, year, starName 
	FROM Movies, StarsIn
	WHERE title=movieTitle AND year=movieYear;

CREATE VIEW StarMovies(title, year, movieStarName) AS SELECT title, year, starName FROM Movies, StarsIn WHERE title=movieTitle AND year=movieYear;