• You could think about something like this:

    SELECT Comp.*

    FROM #Companies AS Comp

    LEFT JOIN #CompanyGroups AS Gr ON Comp.CompanyID = Gr.CompanyID

    WHERE Comp.CompanyID = @CompanyID

    OR GR.CompanyGroupID = @CompanyGroupID