Hi. I have 3 entities: Teacher, Cours, Room.

The relationship Teacher-Cours is 1:n and the relationship Cours-Room is m:n

Now I need to update all the Rooms where there is at least a Cours owned by a certain Teacher.

I'd need something like

'Update Room r set r.valid = true where r in (select elements(cours.rooms) from Cours cours where cours.teacher= :teacher) '

I know elements() is used only in 'where' clause, but I don't know what else can I use here...

Thank you .
Cristi