I would like to join fields from two different databases that reside on the same server, but I am having trouble with the syntax.
Can anyone provide some insight?
I would like to join fields from two different databases that reside on the same server, but I am having trouble with the syntax.
Can anyone provide some insight?
Assuming that your user has privileges in both databases, just reference the "remote" object using three part naming: