Jim Wilcoxson wrote: > > For example, in your query you need to add something like: > and genres.genre = 'drama'. Yes but if I add that I neither get any result:
sqlite3 movies.db "select movies.id,title,year from movies,genres,countries,languages,keywords,tags where movies.id = genres.id and movies.id = countries.id and movies.id = languages.id and movies.id = keywords.id and movies.id = tags.id and genres like 'horror'" The same happens if I use genres.genres instead of only genres. Jim Wilcoxson wrote: > > For this query, only the movies and > genres tables are needed because you aren't selecting any fields from > the other tables, from what I can tell. Yes I know but shouldn't I get all movies with that? I'm getting none... -- View this message in context: http://www.nabble.com/I-need-help-with-very-complex-queries-tp22446301p22447156.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
