SQLite Forum

Query 2 databases
Notice that each database attached to a connection must be cohesive.

That means that you CANNOT have cross schema triggers, indexes, or foreign key constraints.  Other than special dispensation for triggers created in the TEMP schema, this is also simply a fact that, whether you may like or dislike it, is not subject to dispute.