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?

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