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