nuBuilder Forum

Code: Select all

select a.re_id, l2.name afdeling , l.name functie, m1.naam titularis, m2.naam vervanger from contracten a
inner join list l on l.id = a.re_functie
inner join list l2 on l2.id = a.re_afdeling
left join titularis b on a.re_id = b.contract_id
left join medewerkers m1 on m1.id = b.medewerker 
left join vervanging c on c.vv_contract_id = a.re_id and c.vv_parent_id = b.medewerker 
left join medewerkers m2 on m2.id = c.vv_medewerker 
where b.eind is NULL and c.vv_eind is NULL

Code: Select all

M2.namm as naam2