I would like to update 2 fields values from one record to a set of records in the same table:
I tryed this:
UPDATE dd SET dd.comment = y.comment, dd.author = y. author FROM Table1 dd LEFT OUTER JOIN (SELECT * FROM Table1 WHERE Idx=1234) y ON dd.vin = y.vin WHERE dd.vin like '%WLS%'
vin and idx fields are unique keys
My desire is to have the fields comment and author updated from the record which has idx=1234 to all the records whic contain in field vin 'WLS' string.
thanks in advance