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?)