Ansicht StudentComplexReports

  SELECT 
  SCR."Mandant", SCR."ID", SCR."PrevID", SCR."EnbreaID", SCR."StudentAchievement",
  SCR."Profile", SCR."Group", SCR."Entry",
  CASE
    WHEN not SCR."Entry" IS NULL THEN 0  
    WHEN not SCR."Group" IS NULL THEN 1
    ELSE 2    
  END AS "Type",   
  CASE
    WHEN not SCR."Entry" IS NULL THEN 1  
    WHEN not SCR."Group" IS NULL THEN AG."Configuration"
    ELSE AP."Configuration"    
  END AS "Configuration", 
  CASE
    WHEN not SCR."Entry" IS NULL THEN AE."Code"  
    WHEN not SCR."Group" IS NULL THEN AG."Code"
    ELSE AP."Code"    
  END AS "Code",
  CASE
    WHEN not SCR."Entry" IS NULL THEN AE."Name"  
    WHEN not SCR."Group" IS NULL THEN AG."Name"
    ELSE AP."Name"    
  END AS "Name",   
  CASE
    WHEN not SCR."Entry" IS NULL THEN AE."GradeSystem"  
    WHEN not SCR."Group" IS NULL THEN AG."GradeSystem"
    ELSE AP."GradeSystem"    
  END AS "GradeSystem",  
  SCR."Grade", SCR."Report", 
  AG."Position" AS "GroupPosition", 
  AE."Position" AS "EntryPosition"
  FROM "tblStudentComplexReports" SCR
  LEFT JOIN "AssessmentProfiles" AP
  ON  AP."Mandant" = SCR."Mandant"
  AND AP."ID" = SCR."Profile"
  LEFT JOIN "AssessmentGroups" AG
  ON  AG."Mandant" = SCR."Mandant"
  AND AG."Profile" = SCR."Profile"
  AND AG."ID" = SCR."Group"
  LEFT JOIN "AssessmentEntries" AE
  ON  AE."Mandant" = SCR."Mandant"
  AND AE."Profile" = SCR."Profile"
  AND AE."ID" = SCR."Entry"