Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?)
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')