How to copy/query a table from one reporting database to other one?

I have two reporting databses. I want to combine data from specific tables in each databse at one report. What is the best approach?