again new query. i am trying to solve this from one hour. please help
- by Dharmendra
Query : List the film title and the leading actor for all of 'Julie Andrews' films.
there are three tables :
movie(id, title, yr, score, votes, director)
actor(id, name)
casting(movieid, actorid, ord)
select movie.title,actor.name as cont from movie join casting on (movie.id=casting.movieid) join actor on (casting.actorid=actor.id) where actor.name='Julie andrews'
actually i can' get how to find the leading actor.