SELECT DISTINCT 
                      TOP 100 PERCENT dbo.vRiskStepCount.stepCount, dbo.riskItem.likelihood + dbo.riskItem.consequence AS risk, dbo.riskIPT.ipt, dbo.riskIPT.abbrev, 
                      dbo.riskIPT.iptID, dbo.riskItem.itemID, dbo.riskItem.itemNumber, dbo.riskItem.modDT, dbo.riskItem.createDT, dbo.riskItem.tier, dbo.riskItem.initiatedDT, 
                      dbo.riskItem.creatorID, dbo.riskItem.finalRMBA, dbo.riskItem.closureCriteria, dbo.riskItem.description, dbo.riskItem.basicCause, dbo.riskItem.impact, 
                      dbo.riskItem.consC, dbo.riskItem.consS, dbo.riskItem.consT, dbo.riskItem.consequence, dbo.riskItem.likelihood, dbo.riskItem.title, dbo.riskItem.status, 
                      dbo.riskItem.isDraft, dbo.riskItem.isRemoved, dbo.riskItem.origLikelihood, dbo.riskItem.origConsequence, dbo.riskItem.cat, dbo.riskItem.isCritical, 
                      dbo.riskItem.impactOpts, dbo.riskItem.modUserID, dbo.riskItem.closedDT
FROM         dbo.riskItemGroup RIGHT OUTER JOIN
                      dbo.riskIPT INNER JOIN
                      dbo.riskItem ON dbo.riskIPT.iptID = dbo.riskItem.iptID LEFT OUTER JOIN
                      dbo.vRiskStepCount ON dbo.riskItem.itemID = dbo.vRiskStepCount.itemID ON dbo.riskItemGroup.itemID = dbo.riskItem.itemID LEFT OUTER JOIN
                      dbo.riskIPTAdmin ON dbo.riskIPT.iptID = dbo.riskIPTAdmin.iptID
ORDER BY dbo.riskItem.itemID, dbo.riskItem.itemNumber