Pom19: Porovnání verzí
Z Prirucky
| Řádek 1: | Řádek 1: | ||
== Kontroly existence == | == Kontroly existence == | ||
select os_cislo, kod, id_vazby, datum from pichacky where id_vazby not in (select id_vazby from prof_vazba) | select os_cislo, kod, id_vazby, datum from pichacky where id_vazby not in (select id_vazby from prof_vazba) | ||
select os_cislo, kod, id_vazby, datum from pichacky where id_vazby not in | |||
(select id_vazby from prof_vazba where | |||
(dat_od is null or dat_od <= datum) and | |||
(dat_do is null or dat_do >= datum)) | |||
Verze z 3. 2. 2015, 13:56
Kontroly existence
select os_cislo, kod, id_vazby, datum from pichacky where id_vazby not in (select id_vazby from prof_vazba)
select os_cislo, kod, id_vazby, datum from pichacky where id_vazby not in
(select id_vazby from prof_vazba where
(dat_od is null or dat_od <= datum) and
(dat_do is null or dat_do >= datum))
