Hello, Suppose I have this tables: movies: movie,name,rating tags: movie,tag filters: filter,expression
In filters I have: rated,rating != '' tagged,movie in (select movie from tags) Now I want to create a view to relate movies and filters exactly like the tags table: movies_filters: movie,filter Something like this: SELECT 'rated',movie FROM movies WHERE rating != ''; SELECT 'tagged',movie FROM movies WHERE movie in (SELECT movie FROM tags); But from the "filters" table (doesn't work): SELECT filter,movie FROM filters LEFT JOIN movies WHERE movie IN (SELECT movie FROM movie WHERE expression); -- View this message in context: http://old.nabble.com/How-do-I-get-expression-from-column-%28smart-folder-or-filter-implementation%29-tp30295959p30295959.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
