There are a couple ways of joining tables at a SQL level that are on different SQL servers. One such method is with SQL Linked Sever Definitions, which I have used extensively in the past before apps started moving to the Cloud. Of course, any method to do so depends on the servers being able to "see" one another on a common network or via some sort of VPN tunnel. If one or both ends are in the Cloud, such options might not be permitted or available. Depending on your specific requirements, you can copy the rows of the external table to a local real or temp table to which you can then use SQL Join's to local tables. Or, as has been suggested, use perform the Joining in VB.Net using Linq or to a Dictionary or any other creative way you would like.
