UPDATE SELECT FROM Same Table
Posted on 2011-09-28
I'm trying to copy some values from one rec to another within the ame table for repeat orders.
For example, how can i do something like:
SET fld1 = fld1, fld2 = fld2, fld5 = fld5
WHERE id of source rec = 123
WHERE id of target rec = 456
As you see, i purposely omitted fld3 and fld4,, as i need those values unchanged.
How can i do this?