Here is my query:

```
INSERT INTO film_new
(SELECT title, rental_rate,length,film_id,length,release_year FROM film)
JOIN film_actor
    ON film.film_id = film_actor.film_id
JOIN actor
    ON film_actor.actor_id = actor.actor_id

```

and I get the error

> 
> JOIN is not expected
> 
> 
>