Results 1 to 3 of 3

Thread: Update Problem

  1. #1
    Join Date
    Nov 2006
    Location
    Quebec
    Posts
    172

    Unanswered: Update Problem

    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
    Less is more.
    How long is now?
    http://www.lesouterrain.com

  2. #2
    Join Date
    Nov 2006
    Location
    Quebec
    Posts
    172
    #1064 - Erreur de syntaxe pr�s de 'FROM site_medias m
    INNER JOIN site_medias_types mt ON m.med_typ' � la ligne 3
    Less is more.
    How long is now?
    http://www.lesouterrain.com

  3. #3
    Join Date
    Nov 2006
    Location
    Quebec
    Posts
    172
    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
    Less is more.
    How long is now?
    http://www.lesouterrain.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •