View Single Post

   
  #2 (permalink)  
Old 02-28-2008, 07:14 AM
Markus Popp
 
Posts: n/a
Default 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


Reply With Quote