On 8 Aug 2014, at 7:59pm, Simon Slavin <[email protected]> wrote:
> SELECT leadActor.name, movie.title FROM casting > JOIN actor AS leadActor ON leadActor.id = casting.actorid > JOIN movie ON movie.id = casting.movieid > JOIN actor AS selectedActor ON selectedActor.id = casting.actorid > WHERE casting.ord = 1 AND selectedActor.name = 'Julie Andrews' Apologies. This does not actually do what you want. Your main table should actually be movie for this one. JOIN once to find the leadActor, and JOIN again to make sure that Julie Andrews is in it. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
