Join 3 tables with different FKs
<p>I'm trying to join 3 tables together in a SELECT query with some WHERE clauses.
Table 1 is linked to Table 2, and Table 2 is linked to Table 3.</p>

<p>The tables are as follows:</p>

<pre><code>Author
PK: Author_ID
FK: Location_ID
Author_First_Name

Location
PK: Location_ID
City

Articles
PK: Article_ID
FK: Author_ID
Article_Name
</code></pre>

<p>So far I've put together this Query, but am having trouble determining how to to Join the second Foreign Key 'Location_ID'</p>

<pre><code>SELECT 
    Articles.Article_Name 
FROM 
    Articles
        INNER JOIN Author
            ON Articles.Author_ID
        INNER JOIN Location
            ON 
WHERE Author.Author_First_Name='Sam'
AND Location.City&lt;&gt;'Detroit'
</code></pre>