SQL INNER JOIN problem :(

[SoftMax_net]

Hi every1! 🙂

Okay here's my problem, I've been developping a website locally on my machine with mysql 4.x.
But the fact is that on the server it's version 3.23.56.

And my query that I built works with 4.x but not with 3.23.56, maybe you could help me out with this :

SELECT tblusagers.*, tblvilles.Ville, tblregions.Region, tblgroupeage.GroupeAge FROM tblgroupeage INNER JOIN (tblregions INNER JOIN (tblvilles INNER JOIN tblusagers ON tblvilles.ID = tblusagers.idVille) ON tblregions.ID = tblusagers.idRegion) ON tblgroupeage.ID = tblusagers.idGroupeAge WHERE Email='something' AND Password='something' AND EstValide='1'

mysql tells me (version 3.23.56) this error :
You have an error in your SQL syntax near '(tblregions INNER JOIN (tblvilles INNER JOIN tblusagers ON tblvilles.ID = tblusa' at line 1

And tried up many things like putting ' or `around the tables and fields names and didn't worked out!

So that's why i'm posting this!

Thx in advance !

[barand]

See my recent reply here

hth

[SoftMax_net]

thx 😉

But as I have a /%)"/?/"?" load of inner join i'm all /""/%/"% "up 🙁

Wound you mind helping me out?! 😐

[barand]

SELECT tblusagers.*, tblvilles.Ville, tblregions.Region, tblgroupeage.GroupeAge
FROM tblvilles INNER JOIN tblusagers ON tblvilles.ID = tblusagers.idVille INNER JOIN tblregions ON tblregions.ID = tblusagers.idRegion INNER JOIN tblgroupeage ON tblgroupeage.ID = tblusagers.idGroupeAge
WHERE Email='something'
AND Password='something'
AND EstValide='1'

hth

[SoftMax_net]

Ohhhhh! 🙂

Thx a lot 😃

Now I can understand for the next queries I have to change!

THANK YOU SO MUCH 😃