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 ?