Select dBUS.SDOMasterName, B.MinStepOrigin, B.MinStepDest, A.* from
(subquery
) a
INNER JOIN rpt.dimBUSolution dBUS ON dBUS.SolRunMasterID = a.[Run Master ID]
INNER JOIN (select fBUS1.[Run Master ID], min(StepOriginID) MinStepOrigin, min(StepDestinationID) MinStepDest from rpt.FactBUSolution fBUS1 group by fBUS1.[Run Master ID]) B
ON b.[Run Master ID] = a.[Run Master ID]