Best way to overcome lack of joins

Another possible solution: Multiple databases in one question without a data warehouse- YES YOU CAN!

You could just create views in a linked database. Then there’s no need to change your source database. Nor do you need any special rights on the source.

1 Like