title: How to use inner join and cross join in one query?
body: <p>I have a task to write a query that uses a single inner join and cross join(s). The query I have already written that should return the same result looks like this : </p>
  
  <pre><code>SELECT T.PRICE, S.ROW, S.NUMBER, M.TITLE  
  FROM 
  [cinema_no_keys].[dbo].[TICKET] T cross join 
  [cinema_no_keys].[dbo].[MOVIE] M cross join 
  [cinema_no_keys].[dbo].[SEAT] S cross join 
  [cinema_no_keys].[dbo].[SHOW] SH
  WHERE
  T.ID_SEAT = S.ID_SEAT AND
  M.ID_MOVIE = SH.ID_MOVIE AND
  SH.DATE_HOUR = T.DATE_HOUR
  </code></pre>