Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    26

    Unanswered: Update a table with an other

    I need to update a column with a column from another table .. i tried this

    UPDATE Entreprise_2002 as E, Entreprise_LangueNomPrincAdministrateur_done as E2 SET E.languePrincipal = E2.langue WHere E.entrepriseID = E2.EntrepriseID

    AND this to !!

    UPDATE entreprise_2004 as E set LanguePricipal = ( select langue from Entreprise_LangueNomPrincAdministrateur_done as E2 where E.entrepriseID = E2.entrepriseID )

    don't work !!!! please help !

  2. #2
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    UPDATE Entreprise_2002 E
    INNER JOIN
    Entreprise_LangueNomPrincAdministrateur_done E2
    ON E.entrepriseID = E2.EntrepriseID
    SET E.languePrincipal = E2.langue
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

Posting Permissions

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