you can use a UNION in a SQL view to combine multiple selects:
SELECT 'Incident' [Type], pm_id [Number], pm_creation_date [Creation Date], lc_title [Status], CASE WHEN im_is_breached = 1 THEN 'Yes' ELSE 'No' END [Breached?], im_creation_date [Resolution Date] FROM pm_process p INNER JOIN im_incident i ON i.pm_guid = p.pm_guid INNER JOIN lc_status s ON s.lc_guid = p.pm_status_guid LEFT JOIN im_incident_resolution ir ON ir.im_incident_guid = i.pm_guid UNION SELECT 'Request', pm_id, pm_creation_date, lc_title, CASE WHEN rm_is_breached = 1 THEN 'Yes' ELSE 'No' END, rm_creation_date FROM pm_process p INNER JOIN rm_request r ON r.pm_guid = p.pm_guid INNER JOIN lc_status s ON s.lc_guid = p.pm_status_guid LEFT JOIN rm_request_resolution rr ON rr.rm_request_guid = r.pm_guid
will keep that for future reference, I have chosen to create a view for "all received" and then resolved/closed I am keeping separate just to get a report done. I will have a play with your SQL and see if I can make improvements to report.