Ansicht Klassenleiter
Abfrage
??? info "SQL"
``` sql
SELECT
"Mandant", "Klasse", "Zeitraum", "Klassenleiter1" AS "Leiter"
FROM
"KlassenZeitraeume"
WHERE
NOT "Klassenleiter1" IS NULL
UNION SELECT
"Mandant", "Klasse", "Zeitraum", "Klassenleiter2" AS "Leiter"
FROM
"KlassenZeitraeume"
WHERE
NOT "Klassenleiter2" IS NULL
```
Spalten
Diese Ansicht hat 4 Spalten.