SQLite Forum

[Solved] OPEN, ATTACH, CREATE VIEW, SELECT - possible?
>A view cannot be created in one database (or schema) which references objects in another database. This is because a view should remain valid whether other DBs are attached or not.

I believe a temporary view, on the other hand, can.  So, maybe this is the solution to the OP's problem.