• Well you could do it like this if you wanted to =>

    FROM SchoolProgram srp

    INNER JOIN @Programs pr ON srp.ProgramID = 7