sql doesnt work right?

[loco_ola]

this doesnt work on the force 9 server live any ideas? but it does work locally and all information is the same in the database?

Internet Server - 3.23.56 1
Local Server - 4.0.14-nt 1

so is there any way i can make this sql work in both versions?

PHP:

SELECT tblprojects.projectid, tblprojects.projectname, tblprojects.projecticon, tblprojects.projecttext, tblservicedata.servicedataid, tblprojectassociations.projectassociationid, tblprojectassociations.projectid, tblprojectassociations.servicetypeid FROM tblprojects INNER JOIN (tblprojectassociations INNER JOIN tblservicedata ON tblprojectassociations.servicetypeid=tblservicedata.servicedataid) ON tblprojectassociations.projectid=tblprojects.projectid GROUP BY tblprojects.projectid

many thanks

[maxpup979]

ummm--The sql appears to be correct--so I would wonder if the DB you are using on the live side supports inner joins--
If I recall correctly (take this with a grain o salt--my memory ain't what it used to be) mySQL didnt support inner joins until version 4. But I could very well be wrong on that....and you might not be using mySQL--

[loco_ola]

if i make a simpler inner join with only one join it works ok yeah its Mysql.

its driving me crazy!

[maxpup979]

grin...not to be a butthead--but can you switch to something like Postgres?

grin

[loco_ola]

Fraid not. Unless you can host it 🙂