On Tue, Oct 28, 2014 at 4:02 PM, Gerry Snyder <mesmerizer...@gmail.com> wrote:
> A regular (non TEMPORARY) VIEW can reference only tables in the file where > it is stored. SQLite allows qualified names, but the practice should be > avoided because the VIEW won't work if the file is attached under a > different name. > > A TEMPORARY VIEW can reference tables in any attached file, and the use of > qualified names is allowed and encouraged (at least by me). > That info will most certainly save me some future head-scratching. Thanks! -- ----- stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal "Freedom is sloppy. But since tyranny's the only guaranteed byproduct of those who insist on a perfect world, freedom will have to do." -- Bigby Wolf _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
