P
peljo via AccessMonster.com
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
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