Reporting from Two Databases

[adminboy]

Hi there,

I'd like to run a report that has data from different databases.

Is it possible to access the tables from different databases in the SQL statements?

If so, what's the format of the query?

Thanks,
Admin Boy.

[Support]

Hi Adminboy - sorry this is not possible. The query engine can only work off an active connection to one database at a time.