create a view on 2 different databases

[hencyt]

Can someone tell me how to create a view using tables from 2 different databases?

Thanks,
Sunny

 

[JamesLean]

Just qualify the names of your tables using database.owner.table (you can omit the owner if it is dbo).

CREATE VIEW myview
AS

SELECT t1.col1, t2.col2
FROM db1..table1 t1
  JOIN db2..table2 t2 ON t1.id = t2.id
GO

--James

 

[hencyt]

Thanks James!

Sunny