"select * from films c, acteurs a
where a.regiseurid=c.regiseurid and regiseurid=$rgid"
SELECT regiseurid FROM acteurs WHERE regiseurid in
(
SELECT regiseurid
FROM characters
WHERE regiseurid in
( select regiseurid
from films
))
Made by Thijs Aarnoudse