Hi I have a requirement to join two table which are in two different databases. I found the following link to make use of synonym to do the task.
But when I add the Synonym it is not recognized by C#/Visual studio. Please suggest me a solution.
Please tell me a way to join two tables which are in two different databases.