Is it possible to create a database called C that is a view into all tables in database A + B? Using SQL 2005 or 2008, is it possible to create a database called C that is a view into all tables in database A + B ?   Databases A, B, and C  are on the same local server.

I am wanting to be able to create join queries between tables that are in 2 different databases.    Is there another way to do this?
You can create DatabaseC if you want to, but it adds no value. Just use 3 part object names:

SELECT 
   A.col1, B.col2
FROM
   DatabaseA.dbo.TableA A
   JOIN
   DatabaseB.dbo.TableB B ON A.xx = B.xx