Jointure multiple sur la meme table
Bonjour ,
j ai essaye de faire une jointure multiple sur le meme table mais sans resultat:
Voila ma requete:
Code:
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 |
L'erreur qui me donne MYSQL est :
#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.
