JOIN Tables in 2 Databases

It is possible make a View that Join 2 tables in different databases?
Thanks
Bonato Pierantonio
Yes, just define your tables in the form of <database name>.<owner
name>.<table name>
Jacco Schalkwijk
SQL Server MVP
"Bonato Pierantonio" <pbonato@.interfree.it> wrote in message
news:ufz5N6YzEHA.748@.TK2MSFTNGP14.phx.gbl...
> It is possible make a View that Join 2 tables in different databases?
> Thanks
> Bonato Pierantonio
>

JOIN Tables in 2 Databases

It is possible make a View that Join 2 tables in different databases?
Thanks
Bonato PierantonioYes, just define your tables in the form of <database name>.<owner
name>.<table name>
Jacco Schalkwijk
SQL Server MVP
"Bonato Pierantonio" <pbonato@.interfree.it> wrote in message
news:ufz5N6YzEHA.748@.TK2MSFTNGP14.phx.gbl...
> It is possible make a View that Join 2 tables in different databases?
> Thanks
> Bonato Pierantonio
>