• When executing the query with adding the FULL JOIN with where clause like below -

    SELECT Professor.Id AS [Professor.Id], Professor.ProfessorName,

    CASE Professor.HasTenure WHEN 1 THEN 'True' WHEN 0 THEN 'False' ELSE NULL END AS [Has Tenure],

    Class.ProfessorId AS [Class.ProfessorId], Class.ClassName,

    Class.ClassYear, Class.ClassSemester

    FROM Professor

    FULL JOIN Class

    ON Professor.Id = Class.ProfessorId AND Class.ClassYear >= 2011

    WHERE Professor.HasTenure = 'True'

    Then it is giving same results as adding LEFT OUTER JOIN.