Hi there -

The below query is returning everything correctly, except for it returns: RI.Title where it should be returning AC.Title, RM.Name where it should be returning CM.Name, and RI.Description where it should be returning RM.Description, CM.Description, and AC.Description.

Can anybody help with this? Thanks in advance for your assistance!

Select RI.RiskID, RI.RiskModelID, RI.RiskAreaID, RI.Title, RI.Description, RI.Contributingfctrs, RI.MarkedforDeletion, RM.RiskModelID, RM.RiskGroupID, RM.RiskCategoryID, RM.Name, RM.Description, C.ControlID, C.ControlModelID, C.CtrlCostRatingID, C.CtrlOperEffID, C.CtrlClassificationID, C.CtrlFrequencyID, C.CtrlAutomationID, C.Isshared, C.MarkedforDeletion, CM.ControlModelID, CM.ControlGroupID, CM.ControlCategoryID, CM.Name, CM.Description, AC.Title, AC.Description, AC.ExpectedCompletion, AC.StatusComment, AC.RvsdExpectedCmpltn, AC.Closed, AC.MarkedforDeletion from Risk RI
left outer join riskmodel RM on RM.riskmodelID = RI.riskmodelID
left outer join risk_control riskcon on riskcon.riskid = RI.riskID
left outer join control C on C.controlid = riskcon.controlid
left outer join controlmodel CM on CM.controlmodelID = C.controlmodelID
left outer join issue iss on iss.riskid = RI.riskid
left outer join actionplan AC on iss.issueid = AC.issueid
UNION ALL
Select RI.RiskID, RI.RiskModelID, RI.RiskAreaID, RI.Title, RI.Description, RI.Contributingfctrs, RI.MarkedforDeletion, RM.RiskModelID, RM.RiskGroupID, RM.RiskCategoryID, RM.Name, RM.Description, C.ControlID, C.ControlModelID, C.CtrlCostRatingID, C.CtrlOperEffID, C.CtrlClassificationID, C.CtrlFrequencyID, C.CtrlAutomationID, C.Isshared, C.MarkedforDeletion, CM.ControlModelID, CM.ControlGroupID, CM.ControlCategoryID, CM.Name, CM.Description, AC.Title, AC.Description, AC.ExpectedCompletion, AC.StatusComment, AC.RvsdExpectedCmpltn, AC.Closed, AC.MarkedforDeletion from Risk RI
left outer join riskmodel RM on RM.riskmodelID = RI.riskmodelID
left outer join risk_sharedcontrol riskcon on riskcon.riskid = RI.riskID
left outer join control C on C.controlid = riskcon.sharedcontrolid
left outer join controlmodel CM on CM.controlmodelID = C.controlmodelID
left outer join issue iss on iss.riskid = RI.riskid
left outer join actionplan AC on iss.issueid = AC.issueid;