Will there be support for cross database and cross server joins.
I.E Modelling relationships between 2 entitities that can have there locations changed relative to each other.
Can it handle
DB1..Table1 to DB2..Table2 in same server
Server1.DB1..Table1 to Server2.DB2..Table2
The SQL for the above scenarios will vary based on where you are connected and what the linked server names are etc.
is this supported, or will it be in the future.
Thanks and Regards