CREATE OR REPLACE VIEW frontsql.akc_all1
 AS
 SELECT akc_prie.i_akc_prie,
    akc_prie.i_akcia,
    akc_prie.i_priestor,
    akc_prie.odter,
    akc_prie.doter,
    akc_prie.nakl_cena,
    akc_prie.cena,
    akc_prie.i_usporiad,
    akc_prie.pozn,
    akc_prie.c_user,
    akc_prie.osob,
    akc_prie.in_pozn,
    akc_prie.dph,
    priestor.n_priestor,
    priestor.cena1,
    priestor.cena2,
    priestor.cena3,
    priestor.cena4,
    priestor.cena5,
    priestor.cena6,
    priestor.cena7,
    priestor.cena8,
    priestor.cena9,
    priestor.cena10,
    priestor.prev_doba,
    priestor.i_usporiad AS di_usporiad,
    priestor.dph AS ddph,
    priestor.nakl_cena AS dnc,
    usporiad.n_usporiad,
    usporiad.obrazok,
    priestor.kapacita,
    usporiad.popis AS upopis
   FROM ((frontsql.akc_prie akc_prie
     LEFT JOIN frontsql.priestor priestor ON ((akc_prie.i_priestor = priestor.i_priestor)))
     LEFT JOIN frontsql.usporiad usporiad ON ((akc_prie.i_usporiad = usporiad.i_usporiad)));
