Advertisement
Guest User

Untitled

a guest
Mar 14th, 2013
143
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.56 KB | None | 0 0
  1. {SELECT
  2. Distinct2.t_Meter AS t_Meter
  3. FROM ( SELECT DISTINCT
  4.     Extent2.t_Meter AS t_Meter
  5.     FROM    dbo.Movies AS Extent1
  6.     INNER JOIN dbo.OmdbEntries AS Extent2 ON Extent1.movie_ID = Extent2.movie_ID
  7.     INNER JOIN dbo.BoxArts AS Extent3 ON Extent1.movie_ID = Extent3.movie_ID
  8.     INNER JOIN  (SELECT DISTINCT
  9.         Extent4.movie_ID AS movie_ID
  10.         FROM  dbo.MovieToGenres AS Extent4
  11.         INNER JOIN dbo.Genres AS Extent5 ON Extent4.genre_ID = Extent5.genre_ID ) AS Distinct1 ON Distinct1.movie_ID = Extent1.movie_ID
  12.     WHERE 1 = 1
  13. )  AS Distinct2
  14. ORDER BY Distinct2.t_Meter ASC}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement