join of internal and external database tables


I am an Outsystems beginner. I am able to connect to my external database without any problem, but how do I join an internal Entity (User) with an external one (which has the logical database field in the advanced tab filled). I tried to join with an Aggregate and with an SQL, no success. If joining internal and external entities is not possible, what is the most efficient way to show results in the UI that combine the data from the two tables?



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.