Re: Using table from one database in another... Hi,
you can access a table in another database by fully qualifying it, that is
e.g.
select * from [databasename].[tablename];
This way, you can also join two (or more) tables from different databases.
Markus |