A "temp" view, however, can access table from different DBs.
-----Original Message----- From: Gerry Snyder I was under the impression that a view is limited to the tables in the db file where it resides, and have received error messages whenever I tried to access another file's tables.
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users