gideondsouza · August 31, 2012 11:13
diff --git a/Problem11.sql b/Problem11.sql
 SELECT m.title,a.name
 FROM casting c JOIN movie m ON
   m.id = c.movieid
 JOIN actor a ON 
   a.id = c.actorid  AND
   c.ord = 1
 WHERE m.yr = 1962
	SELECT m.title,a.name
	FROM casting c JOIN movie m ON
	m.id = c.movieid
	JOIN actor a ON
	a.id = c.actorid AND
	c.ord = 1
	WHERE m.yr = 1962