It turns out that joining tables between databases is not much harder than joining tables within the same database. With cross database joins, it is really simple:

[cc] SELECT * FROM database_one.table_one AS t1, database_two.table_two AS t2 WHERE t1.id = t2.id; [/cc]