Cross Database Joins

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]