Using the following syntax:-

databasename.tableowner.tablename

e.g.


select * from pyinna.dbo.mytable
select * from pyinna.moynul.mytable
select * from master..sysusers


moynul

This is a multi-part message in MIME format.

------=_NextPart_000_01A7_01C2108D.EF15ED60
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

How do I specify the fully qualified table name so I can join tables in
two databases (on the same SQL-Server 7.0 machine)?
 
I need to do something like this:
 
Select UserName, eMail
FROM LocalTable lt INNER JOIN OuterTable Ot on it.Username = Ot.UserID
 
The OuterTable is a table in a different database (but on the same SQL
Server machine).
 
TIA,
Owen