od
od copied to clipboard
[psp] view na interpelace
neco na zpusob
with osoby as (
select
id_osoba,
jmeno || ' ' || prijmeni as jmeno
from psp.poslanci_osoby
)
SELECT
pr.*, os.jmeno as tazatel, os2.jmeno as dotazovany, los.*, org.*
FROM
psp.interp_poradi pr
inner join osoby os on os.id_osoba = pr.id_poslanec
inner join osoby os2 on os2.id_osoba = pr.id_ministr
INNER JOIN psp.interp_los_interpelaci los on los.id_los = pr.id_losovani
inner join psp.poslanci_organy org on org.id_organ = los.id_org