Ansicht FunktionenSchueler

 SELECT
  "Mandant", "ID" AS "Schueler", "Funktion1" AS "Funktion"
FROM
  "Schueler"
WHERE
  NOT "Funktion1" IS NULL
UNION SELECT
  "Mandant", "ID" AS "Schueler", "Funktion2" AS "Funktion"
FROM
  "Schueler"
WHERE
  NOT "Funktion2" IS NULL
UNION SELECT
  "Mandant", "ID" AS "Schueler", "Funktion3" AS "Funktion"
FROM
  "Schueler"
WHERE
  NOT "Funktion3" IS NULL
UNION SELECT
  "Mandant", "ID" AS "Schueler", "Funktion4" AS "Funktion"
FROM
  "Schueler"
WHERE
  NOT "Funktion4" IS NULL
UNION SELECT
  "Mandant", "ID" AS "Schueler", "Funktion5" AS "Funktion"
FROM
  "Schueler"
WHERE
  NOT "Funktion5" IS NULL
UNION SELECT
  "Mandant", "ID" AS "Schueler", "Funktion6" AS "Funktion"
FROM
  "Schueler"
WHERE
  NOT "Funktion6" IS NULL
UNION SELECT
  "Mandant", "ID" AS "Schueler", "Funktion7" AS "Funktion"
FROM
  "Schueler"
WHERE
  NOT "Funktion7" IS NULL
UNION SELECT
  "Mandant", "ID" AS "Schueler", "Funktion8" AS "Funktion"
FROM
  "Schueler"
WHERE
  NOT "Funktion8" IS NULL