Linking 2 or more databases.

    Hi All,

  I need to get information from 2 (or more) database preferably in one
select statement. Is there a way to join tables from different databases
in the same SQL ? Can I have a 'virtual' foreign key ? Can I make a view
'cross database' ? Can I make some server side programming to accomplish
this task ? Where do I find documentation if any ?

  Thanks for any ideas,

 Leif