How do I set up a sql statement to use as a view?

I want to use two tables but they are both from different databases.

From the Offices database I want to use a table called Office Code and
only the Name column

The other database is called Library and I want to use a table called
Requestors and join it to others.

I've set the stored procedure up that I want to use to get most of the
data besides the data in the offices database.

Create view GetDataview

select requestors.officeCode, requestors.Fname + ' ' +
requestors.Lname as [Name], Titles.title as Title
from requestors

join libraryrequest on libraryrequest.requestorid =
requestors.requestorid
join Titles on Titles.Titleid = libraryrequest.Titleid
where officecode <> 0
order by Officecode
GO

How do I add the database offices, table officecodes to this view to
use the Name column?

I hope this makes sense

JJ297 (nc297 (AT) yahoo (DOT) com) writes:
You refer to a table in a different database with three-part notation.
For instance:

Offices.dbo.[Office Code]


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

On Feb 7, 5:20 pm, Erland Sommarskog <esq... (AT) sommarskog (DOT) se> wrote:
Thanks I got it! I didn't give my user permissions to use the other
table.