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];