Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2005
    Posts
    266

    Unanswered: Update From Select

    the following is not working in ACCESS 2000 (it works perfectly for MS SQL 2000)

    UPDATE Table_A
    SET Name = (SELECT Table_B.Name
    FROM Table_A INNER JOIN Table_B ON Table_A.id = Table_B.id)


    do you know what is wrong ?

    thank you for helping

  2. #2
    Join Date
    Nov 2004
    Location
    Norway
    Posts
    441
    Jet doesn't like that

    Try something like this

    UPDATE Table_A
    INNER JOIN Table_B ON Table_A.id = Table_B.id
    SET Name = Table_B.Name
    Roy-Vidar

  3. #3
    Join Date
    Dec 2005
    Posts
    266
    Perfect ! it works fine

    thanks a lot

Posting Permissions

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