1 Reply Latest reply: Oct 9, 2009 10:00 PM by alejandro hernández RSS

    Help with syntax

       

       

      Sql select
      movie_id,
      movie_title,
      movie_genre
      from ...... ;

      Sql select
      movie_id,
      customer_id,
      country,
      country_id
      from ...... ;

      Sql select
      country_id,
      movie_language
      from ......

       

      I want to create a list where I can only see the movies where the language is DUTCH (if the country_id = 1) and the language is GERMAN (if the country_id = 2) and the language is OTHER (when movie_genre is = 'soap')

      I've tried a few syntaxes but can't get the right one. What is the right code and where do i have to paste it? (in the listproperties or in the codepage?)

        • Help with syntax

          Without knowing the names of your tables:

           


          Sql select
          movie_id,
          movie_title,
          movie_genre
          from Table1;

          Sql select
          movie_id,
          customer_id,
          country,
          country_id
          from Table2 ;
          Sql select
          country_id,
          movie_language
          from Table3;

          Sql Select Table1.movie_title, Table3.movie_language from
          Table1 inner join Table2 on Table1.movie_id = Table2.movie_id
          inner join Table3 on Table2.country_id = table3.Country_id
          where table3.movielanguage in ('DUTCH', 'GERMAN', 'OTHER')