How to join application database and Framework databases tables in same data adapter query

Hello,

You don't give any details on what tables you need to use and what sort of join logic would be needed, so I can only give very general guidance. Nor whether you need to do an inner-join, left-outer join etc..  Or union two tables together?

There might be some Business Rule APIs that combine Framework and Application data , depending on what you need to do.

I have a suspicion that this might have something to do with showing a report that shows user activity, and needing the framework database to lookup the username from the user's uniqueIdentifier (in the Application audit tables).

To join the Framework and Application tables together, assuming I needed to do an inner-join, I would use a Dashboard Data Set Business Rule, and put your Data Adapter on the front of that.

The Business Rule would run the two queries, through separate connections, into two DataTables.
Then you can use features such as LinQ to join the DataTables together in memory.