[thelist] sql update statement using a subquery (sql server)

[r937]

does this work correctly?

UPDATE Reservations
   SET ReservedBy = r2.ReservedBy
  FROM Reservations r
inner
  join Reservations r2
    on r.ParentReservationID = r2.ReservationID
 WHERE r.ReservedBy IS NULL


rudy
http://r937.com/