Hi, I'm not a db/SQL/SQLite expert and this is for sure a newbie question, so
feel free to skip it if you think this is too entry level.
I've a SQLite db containing data about movies.
The main table (movies) contains:
movie_id (autoincrement, primary);
title;
year;
Then I have the actors table:
actor_id (autoincrement);
name;
surname;
Then I have the cast table:
movie_id (related to movies table);
actor_id (related to the actors table);
character_name (the name of the character, eg. "Mrs Doubtfire");
In a single query I should retrieve all the characters of a given movie (at
the application level I've the id of the current movie to start), name and
surname of the actor and a list of the movies (!= this current movie) where
the actor had a role:
Character_name | Actor | Other movies where we've seen
this actor
Mrs Doubtfire | Robin Williams | Mork & Mindy, Dead Poets
Society, ...
Other name | Other actor | Related movies,...
Is this possible? How?
--
View this message in context:
http://old.nabble.com/retrieve-data-from-movie-sqlite-database-tp33077722p33077722.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
