Hello,
I dont understand the following error.
Can anyone help me plz
Thx
Pascal
select *
from sip_vacations_v v
left join
(
select pe.emp_id,mg.mat_id,mg.groupe,count(p.id) * 1.5 as nb_heures
from mat_grp_v mg
inner join planification_v p on p.mat_grp_id = mg.id
inner join planification_ens_v pe on pe.planification_id = p.id
where mg.annee_univ = v.annee and mg.semestre = v.sem_civ
group by pe.emp_id,mg.mat_id,mg.groupe
) p on p.emp_id = v.emp_id
and p.mat_id = v.mat_id
and p.groupe = v.groupe
ERROR: invalid reference to FROM-clause entry for table "v"
LINE 9: where mg.annee_univ = v.annee and mg.semestre = v.sem_civ
^
HINT: There is an entry for table "v", but it cannot be referenced from this part of the query.
