On 6/19/2013 8:18 AM, Clemens Ladisch wrote:
<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.
You seem to have it backwards. The first would be least recent (that is,
oldest); the last would be most recent.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users