We know who directed a specific movie because there is a column named
DirectorId in the
Movie table. If you take a look at "Midnight in Paris", its
DirectorId is 3. So we can now look at the
Director table to find that ID 3 is assigned to Woody Allen. And that's how we know he is the director of this movie.
There are quite a few ways of getting information from multiple tables at the same time. We're going to start with the easiest one.
FROM Person, Car;
You already know how
SELECT * FROM Table works. Now, we just name two tables instead of one, and we separate them with a comma (
,). Piece of cake! However, you might find the result slightly surprising. Let's check that out.