Pramod Jain wrote:
HI Denis,
Welcome to the community :)
You can see the executed query from outsystems Test query and check what query is being created in the background . Yo can also try to execute that query from any client tool and can see what exactly the issue is .
As per my knowledge Sql Server support join in two different database if they are on the same server.
Regards
-PJ-
Is that true?
Let us say you have a User table in SystemDB and AvailableFeatures table in FeaturesDB. When I try to join these two tables in an aggregate, I get a "Invalid Aggregate: Aggregate cannot join data from multiple databases. Change it to only use entities from a single database." message.
Ravi