mysql left join and inner join 3 tables
<p>I have 3 tables: oc_artists, oc_songs, oc_songs_tags</p>

<p>I can select 2 tables with this code:</p>

<pre><code>SELECT * FROM `oc_songs` LEFT JOIN oc_songs_tags ON oc_songs.song_id=oc_songs_tags.song_id 
WHERE oc_songs_tags.song_tag IS NULL
</code></pre>

<p>Now I need to select data from oc_artists... I tried this questions answer:
<a href="https://stackoverflow.com/questions/16222097/mysql-left-join-3-tables">MySQL LEFT JOIN 3 tables</a></p>

<p>And here is my code:</p>

<pre><code>SELECT * FROM oc_songs
LEFT JOIN oc_artists
    INNER JOIN oc_songs_tags
    ON oc_songs.song_artist_id = oc_artists.artist_id
ON oc_songs_tags.song_id = oc_songs.song_id
</code></pre>

<p>But I am getting this error</p>

<pre><code>8 errors were found during analysis.

Unrecognized keyword. (near "ON" at position 131)
Unexpected token. (near "oc_songs_tags" at position 134)
Unexpected token. (near "." at position 147)
Unexpected token. (near "song_id" at position 148)
Unexpected token. (near "=" at position 156)
Unexpected token. (near "oc_songs" at position 158)
Unexpected token. (near "." at position 166)
Unexpected token. (near "song_id" at position 167)
</code></pre>