Results 1 to 2 of 2

Thread: a little help

  1. #1
    Join Date
    Dec 2003
    Posts
    9

    Unhappy Unanswered: a little help

    i have a "Stores" table with some fields including a "Region" field and a "Ware" field. Now, I also have a "WH" table with two fields, "Region" and "WH Name"

    Now my question is this. how do i make a query so that i can update the "Ware" field in the "Stores" table with the corresponding "WH Name" from the "WH" table. the relationship between the two is the region that they are in. does this make any sense?

  2. #2
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    I don't know what your primary and foreign keys are, so I guessed:

    UPDATE Stores INNER JOIN WH ON Stores.Region = WH.Region SET Stores.Ware = [WH Name];

Posting Permissions

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