This tutorial introduces the notion of a join. The database consists of three tables movie, actor and casting.
More details about the database.
Limbering up
Looking at the id field.
That's plenty joins for now. Students with an unhealthy interest in databases or movies may try the following harder questions; although they might be better advised to go out and get some fresh air.
That is definitely enough. Students should, under no circumstances look at the next tutorial, concerning outer joins.