Hello! I did try
$ sqlite3 :memory: SQLite version 3.6.11 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> attach database 'merch.db' as work; sqlite> create view test as select * from work.users; SQL error: view test cannot reference objects in database work But it's work some time ago! How can I create view for attached databases now? Create table is bad becouse attached database may be huge. Best regards. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
