Bonjour ,
j ai essaye de faire une jointure multiple sur le meme table mais sans resultat:
Voila ma requete:
L'erreur qui me donne MYSQL est :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16 SELECT press.press_id, press.press_date, prd.pl_value AS descript, prt.pl_value AS title, prp.pl_value AS pdf, FROM press LEFT JOIN press_langue AS prt ON press.press_id = prt.press_id LEFT JOIN press_langue AS prd ON press.press_id = prd.press_id LEFT JOIN press_langue AS prp ON press.press_id = prp.press_id WHERE press.press_id IN ( '179', '92', '126', '99', '90', '149' ) AND prt.pl_type = 'title' AND prt.langue = 'FR' AND prd.pl_type = 'descript' AND prd.langue = 'FR' AND prp.pl_type = 'pdf' AND prp.langue = 'FR' LIMIT 0 , 30
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM press LEFT JOIN press_langue AS prt ON press . press_id = prt . press_id ' at line 1
merci d'avance de votre AIDE.
Partager