views from different database

[mayo]

just want to ask, is it possible to create views in which i will join tables from two different database? how?

[ck9663]

just want to ask is it possible to create views i which i will join tables from two different database? how?

yes.

create your query first. then create it as view. if you need to change any part of the query (table, where condition) based on some parameter, a function returning a table would be better.

[mayo]

yes.

create your query first. then create it as view. if you need to change any part of the query (table, where condition) based on some parameter, a function returning a table would be better.

i mean combining data from multiple database? whats the syntax?

[ck9663]

i mean combining data from multiple database? whats the syntax?

yes...name your table properly....dbname.ownername.tablename

create view myview
as
 
select table1.field1, table2.field2 
from db1.dbo.tablel1
inner join db2.dbo.table2 on table1.key = table2.key
 
go

i did not the syntax on this command...but i hope you got the ideae