dochsm wrote: > I would have thought having no database prefix would default to the > main
<http://www.sqlite.org/lang_attach.html> says: | If two or more tables in different databases have the same name and | the database-name prefix is not used on a table reference, then the | table chosen is the one in the database that was least recently | attached. As the first (i.e., most recently) attached, main always loses. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users