2009/12/6 Yuzem <[email protected]>: > > 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
