Ansicht StudentAchievements

  SELECT
    SA."Mandant", SA."ID", SA."PrevID", SA."EnbreaID", SA."StudentTerm", 
    SA."AchievementProfile", 
    AP."Code" AS "ProfileCode", AP."Name" AS "ProfileName", AP."Course",    
    F."Kuerzel" AS "CourseCode",
    F."Bezeichnung" AS "CourseName",
    CASE 
      WHEN (C."CourseNo" IS NULL) THEN F."Kuerzel" 
      WHEN (C."CourseNo" = 0) THEN F."Kuerzel"
      ELSE F."Kuerzel" || C."CourseNo" 
    END AS "CourseDisplayName", 
    AP."Configuration", 
    AP."GradeType", GT."Code" AS "GradeTypeCode", GT."Name" AS "GradeTypeName",
    AP."AssessmentProfile", ASP."Code" AS "ASPCode", ASP."Name" AS "ASPName",     
    AP."GradeSystem", SA."Grade", SA."GradeFactor", SA."Report", SA."Position"
  FROM "tblStudentAchievements" SA
  LEFT JOIN "AchievementProfiles" AP
  ON  AP."Mandant" = SA."Mandant"
  AND AP."ID" = SA."AchievementProfile"
    LEFT JOIN "GradeTypes" GT
    ON  GT."Mandant" = AP."Mandant"
    AND GT."ID" = AP."GradeType"
    LEFT JOIN "AssessmentProfiles" ASP
    ON  ASP."Mandant" = AP."Mandant"
    AND ASP."ID" = AP."AssessmentProfile"
    LEFT JOIN "tblCourses" C
    ON  C."Mandant" = AP."Mandant"
    AND C."ID" = AP."Course"
      LEFT JOIN "Faecher" F
      ON  F."Mandant" = C."Mandant"
      AND F."ID" = C."Subject"