Multiple databases

[ifahsozasuaw]

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!

[kfleming]

You would need to export data to dbf from the SQL version and then use the Xbase version to combine the exported DBF with your existing tables.____Kathleen__R&R Support