Penzijní připojištění a bankovní účty (sestava)

Penzijní připojištění a bankovní účty (sestava)

Sestava

SQL definice

select EVP.os_cislo, A.prijmeni, A.jmeno, A.rodne_cislo, EVP.fond, 
OS.nazev, EVP.c_smlouvy, EVP.varianta, EVP.indik, EVP.castka, EVP.dat_od, EVP.dat_do, EVP.perioda,

(select max(kod) from platby PL where PL.os_cislo = EVP.os_cislo and
(dat_do is null or dat_do > (select datum_prvni from par_map)) and
PL.kod in (select pp_srazky from param_pp where pp_kod = (select c_pole2 from osoby_typ where id_osoby = EVP.fond))) as kod_zamtel,

(select max(mes_castka) from platby PL where PL.os_cislo = EVP.os_cislo and
(dat_do is null or dat_do > (select datum_prvni from par_map)) and
PL.kod in (select pp_srazky from param_pp where pp_kod = (select c_pole2 from osoby_typ where id_osoby = EVP.fond))) as mescastka_zamtel,

(select max(cislo_banky) from platby PL where PL.os_cislo = EVP.os_cislo and
(dat_do is null or dat_do > (select datum_prvni from par_map)) and
PL.kod in (select pp_srazky from param_pp where pp_kod = (select c_pole2 from osoby_typ where id_osoby = EVP.fond))) as banka_zamtel,

(select max(cislo_platby) from platby PL where PL.os_cislo = EVP.os_cislo and
(dat_do is null or dat_do > (select datum_prvni from par_map)) and
PL.kod in (select pp_srazky from param_pp where pp_kod = (select c_pole2 from osoby_typ where id_osoby = EVP.fond))) as ucet_zamtel,

(select max(var_symb) from platby PL where PL.os_cislo = EVP.os_cislo and
(dat_do is null or dat_do > (select datum_prvni from par_map)) and
PL.kod in (select pp_srazky from param_pp where pp_kod = (select c_pole2 from osoby_typ where id_osoby = EVP.fond))) as varsym_zamtel,

(select max(konst_symb) from platby PL where PL.os_cislo = EVP.os_cislo and
(dat_do is null or dat_do > (select datum_prvni from par_map)) and
PL.kod in (select pp_srazky from param_pp where pp_kod = (select c_pole2 from osoby_typ where id_osoby = EVP.fond))) as konst_zamtel,

(select max(spec_symb) from platby PL where PL.os_cislo = EVP.os_cislo and
(dat_do is null or dat_do > (select datum_prvni from par_map)) and
PL.kod in (select pp_srazky from param_pp where pp_kod = (select c_pole2 from osoby_typ where id_osoby = EVP.fond))) as spec_zamtel,

null as nothing,
 
(select max(kod) from platby PL where PL.os_cislo = EVP.os_cislo and
(dat_do is null or dat_do > (select datum_prvni from par_map)) and
PL.kod in (select c_pole3 from osoby_typ where id_osoby = EVP.fond)) as kod_zamec,

(select max(mes_castka) from platby PL where PL.os_cislo = EVP.os_cislo and
(dat_do is null or dat_do > (select datum_prvni from par_map)) and
PL.kod in (select c_pole3 from osoby_typ where id_osoby = EVP.fond)) as mescastka_zamec,

(select max(cislo_banky) from platby PL where PL.os_cislo = EVP.os_cislo and
(dat_do is null or dat_do > (select datum_prvni from par_map)) and
PL.kod in (select c_pole3 from osoby_typ where id_osoby = EVP.fond)) as banka_zamec,

(select max(cislo_platby) from platby PL where PL.os_cislo = EVP.os_cislo and
(dat_do is null or dat_do > (select datum_prvni from par_map)) and
PL.kod in (select c_pole3 from osoby_typ where id_osoby = EVP.fond)) as ucet_zamec,

(select max(var_symb) from platby PL where PL.os_cislo = EVP.os_cislo and
(dat_do is null or dat_do > (select datum_prvni from par_map)) and
PL.kod in (select c_pole3 from osoby_typ where id_osoby = EVP.fond)) as varsym_zamec,

(select max(konst_symb) from platby PL where PL.os_cislo = EVP.os_cislo and
(dat_do is null or dat_do > (select datum_prvni from par_map)) and
PL.kod in (select c_pole3 from osoby_typ where id_osoby = EVP.fond)) as konst_zamec,

(select max(spec_symb) from platby PL where PL.os_cislo = EVP.os_cislo and
(dat_do is null or dat_do > (select datum_prvni from par_map)) and
PL.kod in (select c_pole3 from osoby_typ where id_osoby = EVP.fond)) as spec_zamec

from ev_p_prisp EVP, pracovnici A, osoby OS where 
EVP.os_cislo = A.os_cislo and EVP.fond = OS.id_osoby

Odkazy

• Generátor sestav II (příklady sestav)
• hd 65990