Multiple databases
Posted: Thu Jan 22, 2009 9:45 am
Is it possible to join two tables from two different databases? We have our data stored in separate databases than our client^s data and need to create reports that access both sides. When I try to join the SQL databases, I can only access the database where the default table lies. I have both databases separate in the ODBC list and have both databases connected already. Still no luck on joining them. Thanks!