MySQL Forums
Forum List  »  Newbie

Probleme de requete sur serveur
Posted by: webmaster
Date: July 01, 2005 05:25AM

Voila, j'ai un probleme. la requete ci-dessous marche correctement dans mysql en local (localhost) mais lorsque je suis sur le serveur, elle me renvoi cete erreur :


#1064 - You have an error in your SQL syntax near '(
admin
INNER JOIN droit ON admin.id = droit.id_user
) ON access.ida = droi' at line 3

Quelqu'un peut-il m'aider a comprendre ?
Merci d'avance
(Reply in French Only thanks)
voici la Requete :

SELECT login
FROM access
INNER JOIN (
admin
INNER JOIN droit ON admin.id = droit.id_user
) ON access.ida = droit.id_access
LIMIT 0 , 30

Options: ReplyQuote


Subject
Written By
Posted
Probleme de requete sur serveur
July 01, 2005 05:25AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.