I am not all a SQL expert but have to create a query which displays data from 2 different databases.
Please see attached image -
I have Database A Table 1 which lists my applications and their job execution status
I have Database B Table 1 which lists my application availability status
As shown in attachment I need to join each database and table in question for 1 report which shows both application availability along with each applications total failed job count along with availability for past day as opposed to every hour of the day.
The only way I am able to relate both tables is via part of the application name being in the the job_name column of Database A and AppName column of Database B. For example "App1"
I have no idea if / how it is possible to join 2 databases where as in this case the common application name not represented the same way in each database.