--
-- What was the title of season 1, episode 1 of The Simpsons
-- (using join operator)
--

use imdb;

select p1.title
from productions p1 join episodes join productions p2
on p1.tcode = episodes.ecode
and episodes.scode = p2.tcode
where p2.title = 'The Simpsons'
and season = 1
and epnum =1;