Monthly Report of completed jobs grouped by Application

[Legacy User]

I need to quickly pull together completed jobs grouped by Application, yet I do not find Application in the history table. 
1. What tables are needed to merge this information with the job history 
2. How do I merge the tables

The application information for jobs in history are located in the aw_jh_view. The column is so_application. The rest of the information in the view is the same as the so_job_history table.

[Kim_Veltman_10331]

This answered #1.

How do I merge the tables to get desired results?

[Kristopher_Thomas_221]

You can query the aw_jh_view directly to get application along with all of the details found in the so_job_history table. There is no need to merge the tables as the view already does this.