Inner Join error, three tables

Course Q&A Data Engineering Data Storage and Queries
1

In the Advanced SQL Queries assignment, exercise 10, I can’t get the inner join to work. I’m using dim_actor as the main table. The first inner join line works but then the next two don’t. They reference two different table and neither are dim_actor. This construct doesn’t seem right.

FROM
    None
    INNER JOIN None ON None.None = None.None
    INNER JOIN None ON None.None = None.None
    INNER JOIN None ON None.None = None.None
2

Hello @mkorangestripe
It’s ok that none of the tables in the last two inner joins is dim_actor. We already joined this table with bridge_actor. Then we join fact_rental with bridge_actor, and finally we join dim_film with fact_rental. Therefore the properties propagate in each join. Please, let us know if you have difficulty following the instructions to replace the Nones in the code snippet with the correct values.

3

I rewrote the INNER JOINs one at a time following the graph from earlier in the lab. I had the table from the previous INNER JOIN in the wrong place. The query returns the expected results now. Thanks