Update query

[samotek]

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 ?

 

[samotek]

Just to add that productid in both tables are autonumber field

 

[HarleyQuinn]

What does it do? Does it pop up and tell you it's going to update 0 rows?

I've just tried your exact query and it works fine for me (as expected).

Might sound a daft question but there are matching ProductID's in both tables aren't there?

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[JoeAtWork]

I want to build a query where the data from the table products1 to be inserted into the table products.

Might I suggest an INSERT query then?

INSERT INTO Products SELECT * FROM Products2