Requete UPDATE avec JOIN

Bonjour,

Je me débat avec une requete UPDATE nécessitant un JOIN sachant que 2 champs ont des noms identiques (nécessite un AS aussi, donc).

Voici la requete que j'utilise :

Code:

---

1 2 3 4 5

UPDATE a SET a.access=1 FROM `content` AS a LEFT JOIN `categories` AS b ON a.catid = b.id WHERE a.access='0' AND b.access='1'

---

Celle-ci me renvoie un message d'erreur :

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 `content` AS a
LEFT JOIN `categories` AS b ON a.catid = b.id
WHERE a.acc' at line 2


Je sèche... Quelqu'un a une idée ??

Salut.

Code:

---

1 2 3 4 5

UPDATE a SET a.access=1 FROM `content` AS a LEFT JOIN `categories` AS b ON a.catid = b.id WHERE a.access='0' AND b.access='1'

---

Remplacé par

Code:

---

1 2 3 4

UPDATE CONTENT tA LEFT JOIN CATEGORIES tB ON tA.catid = tB.id SET tA.access = 1

---

ça ne marche pas mieux??

Effectivement...

La requete :

Code:

---

1 2 3 4 5

UPDATE content tA LEFT JOIN categories tB ON tA.catid = tB.id SET tA.access = 1 WHERE tA.access=0 AND tB.access=1

---

marche mieux...

MERCI ! :ccool: