Q: view over databases

Hello,
How can I write a view that gets data from different database in the same
Database server?
Qualify object names with the database name:
SELECT count(*)
FROM master.dbo.sysobjects as A
JOIN model.dbo.sysobjects as B
ON A.id = B.id
WHERE A.name <> B.name
Roy
On Wed, 22 Feb 2006 12:56:28 -0800, JIM.H.
<JIMH@.discussions.microsoft.com> wrote:

>Hello,
>How can I write a view that gets data from different database in the same
>Database server?
>