CREATE OR REPLACE VIEW dotaznik 
  (osoba, vek, pohlavi, vyska, vaha, prijem, povolani, kraj, otazka1, otazka2, otazka3, otazka4, otazka5, otazka6, otazka7, otazka8, otazka9, otazka10, otazka11, otazka12)
AS
SELECT id_osoby, vek, pohlavi, vyska, vaha, prijem, povolani.nazev, kraj.nazev, o1.text, o2.text, o3.text, o4.text, o5.text, o6.text, o7.text, o8.text, o9.text, o10.text, o11.text, o12.text
FROM osoby NATURAL JOIN 
      kraj JOIN
      povolani USING (id_povolani) LEFT JOIN
      (SELECT text, id_osoby FROM odpovedi NATURAL JOIN moznosti WHERE id_otazky=1)o1 USING (id_osoby) LEFT JOIN
      (SELECT text, id_osoby FROM odpovedi NATURAL JOIN moznosti WHERE id_otazky=2)o2 USING (id_osoby) LEFT JOIN
      (SELECT text, id_osoby FROM odpovedi NATURAL JOIN moznosti WHERE id_otazky=3)o3 USING (id_osoby) LEFT JOIN
      (SELECT text, id_osoby FROM odpovedi NATURAL JOIN moznosti WHERE id_otazky=4)o4 USING (id_osoby) LEFT JOIN
      (SELECT text, id_osoby FROM odpovedi NATURAL JOIN moznosti WHERE id_otazky=5)o5 USING (id_osoby) LEFT JOIN
      (SELECT text, id_osoby FROM odpovedi NATURAL JOIN moznosti WHERE id_otazky=6)o6 USING (id_osoby) LEFT JOIN
      (SELECT text, id_osoby FROM odpovedi NATURAL JOIN moznosti WHERE id_otazky=7)o7 USING (id_osoby) LEFT JOIN
      (SELECT text, id_osoby FROM odpovedi NATURAL JOIN moznosti WHERE id_otazky=8)o8 USING (id_osoby) LEFT JOIN
      (SELECT text, id_osoby FROM odpovedi NATURAL JOIN moznosti WHERE id_otazky=9)o9 USING (id_osoby) LEFT JOIN
      (SELECT text, id_osoby FROM odpovedi NATURAL JOIN moznosti WHERE id_otazky=10)o10 USING (id_osoby) LEFT JOIN
      (SELECT text, id_osoby FROM odpovedi NATURAL JOIN moznosti WHERE id_otazky=11)o11 USING (id_osoby) LEFT JOIN
      (SELECT text, id_osoby FROM odpovedi NATURAL JOIN moznosti WHERE id_otazky=12)o12 USING (id_osoby) 
WHERE (o1.text IS NOT NULL) OR  (o2.text IS NOT NULL)OR (o3.text IS NOT NULL) OR (o4.text IS NOT NULL) OR (o5.text IS NOT NULL) OR (o6.text IS NOT NULL) OR (o7.text IS NOT NULL) OR (o8.text IS NOT NULL) OR (o9.text IS NOT NULL) OR (o10.text IS NOT NULL) OR (o11.text IS NOT NULL) OR (o12.text IS NOT NULL)