Linking more than 2 tables using SQL

[d_smiff]

Is this possible?

I've tried multiple combinations of INNER JOIN, but am having absolutely no luck whatsoever. So, I was wondering if it iactually possible to do this! I'm sure it is - I just don't know how to do it 🙁

There are 3 tables:

3choons_dj_profiles
dj_id
dj_name
3choons_styles
style_id
style_name
3choons_mixes
mix_id
mix_djid
mix_styleid

What I need is for all of the records to be displayed from the 3choons_mixes table, outputting dj_name and style_name

This is the SQL query that I've put together that obviously doesn't work...

SELECT mix_stream, mix_download, mix_mp3, dj_djname, mix_name, mix_styleid
FROM 3choons_mixes (INNER JOIN 3choons_dj_profiles (ON mix_djid = dj_id)) ON 3choons_mixes.mix_styleid = 3choons_styles.style_id
ORDER BY mix_id DESC

[d_smiff]

No worries - I figured it out for myself 😃

SELECT style_name, mix_stream, mix_download, mix_mp3, dj_djname, mix_name, mix_styleid, mix_id
FROM 3choons_styles, 3choons_mixes INNER JOIN 3choons_dj_profiles ON mix_djid = dj_id
WHERE mix_styleid = style_id
ORDER BY mix_id DESC

If anyone else has any other ideas on how to do it, please feel free to post 🙂