>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.