2017-02-02, 13:54
Hello all!
I'm trying to pull a list of movies, files, actors roles. I want to get something like this.
Star Wars.avi Star Wars: A New Hope Mark Hamill Luke Skywalker
IndianaJones.mkv Raiders of the Lost Ark Harrison Ford Indy
Star Wars.avi Star Wars: A New Hope Harrison Ford Han Solo
I can JOIN the video99.movie table to the video99.file table ON idFile but I can't work out how to get to actors. The movie table has idMovie column but actor_link only has media_id.
Can someone point me to the missing step?
UPDATE
SELECT movie.c00, actor.name FROM movie INNER JOIN actor_link ON actor_link.media_id=movie.idMovie INNER JOIN actor ON actor_link.actor_id=actor.actor_id ORDER BY c00;
That worked, I was right that mediaid and movieID were the same but i'd left the table. off one of the JOIN statements
I'm trying to pull a list of movies, files, actors roles. I want to get something like this.
Star Wars.avi Star Wars: A New Hope Mark Hamill Luke Skywalker
IndianaJones.mkv Raiders of the Lost Ark Harrison Ford Indy
Star Wars.avi Star Wars: A New Hope Harrison Ford Han Solo
I can JOIN the video99.movie table to the video99.file table ON idFile but I can't work out how to get to actors. The movie table has idMovie column but actor_link only has media_id.
Can someone point me to the missing step?
UPDATE
SELECT movie.c00, actor.name FROM movie INNER JOIN actor_link ON actor_link.media_id=movie.idMovie INNER JOIN actor ON actor_link.actor_id=actor.actor_id ORDER BY c00;
That worked, I was right that mediaid and movieID were the same but i'd left the table. off one of the JOIN statements