On 29 Mar 2017, at 1:34am, Domingo Alvarez Duarte <mingo...@gmail.com> wrote: > > It seems sqlite look first if there is a temp.table before main.table and > without qualification temp.table is used.
You got it. It’s not obvious that this is what SQLite would do. But now you know it you understand what is happening. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users