Write a SQL query to retrieve the titles of the movies and the names of their directors.

Question

Given the following 'movies' and 'directors' tables:
```
movies:
| movie_id | title   | director_id |
|----------|---------|-------------|
| 1        | Movie A | 1           |
| 2        | Movie B | 2           |
| 3        | Movie C | 1           |

directors:
| director_id | name        |
|-------------|-------------|
| 1           | Director 1  |
| 2           | Director 2  |
```
Which SQL query is the best way to retrieves the titles of the movies and the names of their directors?

Accepted Answer

SELECT movies.title, directors.name FROM movies INNER JOIN directors ON movies.director_id = directors.director_id;

Answer

SELECT movies.title, directors.name FROM movies CROSS JOIN directors WHERE movies.director_id = directors.director_id;

Answer

SELECT movies.title, directors.name FROM movies LEFT JOIN directors ON movies.director_id = directors.director_id;

Answer

SELECT movies.title, directors.name FROM movies, directors WHERE movies.director_id = directors.director_id;

Question from the SQL - Fundamentals test

Write a SQL query to retrieve the titles of the movies and the names of their directors.