Update Problem

ortho · #1 (**permalink**) 12-22-07, 17:47

Hi all!

I have a problem with an update statement wich I dont unsderstand why it fails.

here my query:

Code:

 UPDATE m SET m.med_type_id = mt.med_type_id FROM site_medias m INNER JOIN site_medias_types mt ON m.med_type = mt.med_type

Help please

ortho · #2 (**permalink**) 12-22-07, 17:48

#1064 - Erreur de syntaxe pr�s de 'FROM site_medias m
INNER JOIN site_medias_types mt ON m.med_typ' � la ligne 3

ortho · #3 (**permalink**) 12-22-07, 18:04

It's ok I finnaly figured it out.

Code:

UPDATE site_medias m
LEFT JOIN site_medias_types mt ON m.med_type=mt.med_type
SET m.med_type_id=mt.med_type_id