Inner join from two seperate database

[JMARZ]

I'm trying to complete an inner join where one of the tables is in another database.

Does anybody have any working examples of this or am I dreaming that I can do this?

 

[Pat Hartman]

Link the table from the other database. You can then use it in a query as if it were local.