How do I join two databases when there is a "." in the table name.
Posted on 2009-05-19
I am attempting to join two databases on the same sql server. I am able to access the databases like so for most of the tables:
SELECT s.item1,b.item2 FROM db1.dbo.t1 s join db2.dbo.t1 b on s.id1 = b.uid1
But when i need to access a view from db1 that contains a "." in the name of the actual table I get a sys.servers prompting me to add the server name. Example below:
SELECT s.item1,b.item2 FROM db1.dbo.name.v1 s join db2.dbo.t1 b on s.id1 = b.uid1
Unfortunately I cant change the name of the view "name.v1". Any help would be appreciated.