Avatar of Jimbo99999
Jimbo99999Flag for United States of America

asked on 

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
.NET ProgrammingDatabases

Avatar of undefined
Last Comment
Avodah
SOLUTION
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

Blurred text
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.
See Pricing Options
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

Blurred text
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
Avatar of Avodah
Avodah
Flag of United Kingdom of Great Britain and Northern Ireland image

Blurred text
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
.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
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo