Results 1 to 3 of 3

Thread: Update query

  1. #1
    Join Date
    Oct 2005
    Posts
    23

    Unanswered: Update query

    I want to build a query where the data from the table products1 to be inserted into the table products.
    I have made he following query which does not update :
    UPDATE products INNER JOIN products1 ON products.Productid = products1.Productid SET products.branch5 = [products1].[branch5];
    The figures in table products do not show the figures from tble products1.
    Why is it so ?

  2. #2
    Join Date
    Oct 2005
    Posts
    23
    Just to add that productid are autonumber fields in both tables

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Hi Samotek,

    You've used two contrasting words in your explanation
    Quote Originally Posted by samotek
    I want to build a query where the data from the table products1 to be inserted into the table products.
    UPDATE products
    ...
    I also note that you have a field called Branch5 - can you explain your table structure to me?
    George
    Home | Blog

Posting Permissions

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