update query updates 0 records

[peljo]

My query does not update and i guess i have built it false.From 2 tables, orders and orders1, having identical structire but with different ID, i want to to copy the order number from table orders1, there is only one record there, and paste in on the field paragonsum in the table orders. In other words, i i want to update the field paragonsum from the table orders to be equal to the field orderif from the tble orders1.I get no errors but o records are updated.Could i update it?

My sql is :
UPDATE orders INNER JOIN orders1 ON [orders].[orderid]=[orders1].[orderid] SET orders.paragonsum = [orders1].[orderid];

gives no errors, but updates 0 records

 

[Remou]

Have you checked using a Select query that there are records to update?

 

[r937]

... having identical structire but with different ID

if orders1 has only one row with a different ID, then how did you expect the following to work...


ON [orders].[orderid]=[orders1].[orderid]


try this --

UPDATE orders
SET paragonsum =
( SELECT max(orderid) FROM orders1 )





r937.com | rudy.ca