SELECT a.title, b.name FROM movie a JOIN 
(SELECT movieid, name FROM casting LEFT OUTER JOIN  actor ON(casting.actorid=actor.id)) b
ON (a.id=b.movieid)
WHERE a.yr = 1962

SELECT a.title FROM movie a WHERE yr=1962