2009/12/6 Yuzem <naujnit...@gmail.com>: > > Is this a bug in new versions that will be fixed or it is the new behavior?
In 3.6.20, so long as you include the alias, you will get your expected results: SELECT movies.id, title, files, icon_modified, icon_width FROM ( movies NATURAL LEFT JOIN files) AS movies NATURAL LEFT JOIN icons_movies LIMIT 25; Regards, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users