Writing Select statement to join multiple tables
Change the INNER JOIN to LEFT JOIN. There's a chance there are missing foreign key values that are causing it to not find any matches across the whole set.

Where you see NULL in the result set, will be an indicator where there is no matching foreign key.