Re: [sqlite] Multiples natural left joins problem

[Yuzem]

> You have not specified your version, but I can repeat your
> difficulties when using version 3.6.19 and 3.6.20
> 
I am using version 3.6.16



> You can get 'correct' results if you modify your query to
> SELECT movies.id, title, files, icon_modified, icon_width
> FROM ( movies natural left join files) as movies natural left join
> icons_movies
> LIMIT 25;
> 
This gives me exactly the same result as the other.
-- 
View this message in context: 
http://old.nabble.com/Multiples-natural-left-joins-problem-tp26627140p26645257.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