Arbon,

Assuming the other database is on the same server, you would prefix the
table name with the database name like so:

Select * from OtherDatabase.dbo.OtherTable

Note the use of the table owner before the table name.  If you have linked
servers, you can extend the syntax to include tables in databases on other
servers by prefixing the foregoing syntax with the server name:

ServerName.DatabaseName.OwnerName.TableName

HTH,

--
Jeff Wilson
President
The Boolean Group, Inc.
(xxx) xxx-xxxx
Glendale, CA



"Arbon Reimer" <arbon_reimer@h...> wrote in message
news:66599@s..._language...
>
> Hi!  I have Microsoft SQL 2000 Server and know there's a way to tell SQL
> Server to use a table in another database as if it were in the current
> one...  I wish to look up an account number in another database and I know
> USE won't work... can anyone help me remember the system stored procedure
to
> do that?
>
> Thank you all very much
>
> Regards
> Arbon Reimer
>
>