VB.Net SQL Query 2 Tables Different Databases
Good Day Experts!
I find myself in a bit of a jam here. Long story short I need help with a query in which I need to join a table in a different database using data on the record from the first table.
Invoice --> 1234
Account --> ABC0101
Table --> Staging
DataBase --> A
Orders --> multiple records
Invoice --> 1234
Database --> ABC0101
Table --> Orders
I am having trouble figuring out how to use the Account data from Staging table as the Database for the second table so I can join on Invoice.
Is this possible? Databases are on the same server.
Thansk,
jimbo99999
I find myself in a bit of a jam here. Long story short I need help with a query in which I need to join a table in a different database using data on the record from the first table.
Invoice --> 1234
Account --> ABC0101
Table --> Staging
DataBase --> A
Orders --> multiple records
Invoice --> 1234
Database --> ABC0101
Table --> Orders
I am having trouble figuring out how to use the Account data from Staging table as the Database for the second table so I can join on Invoice.
Is this possible? Databases are on the same server.
Thansk,
jimbo99999
Last Comment
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
.NET Programming
The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.
137K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
