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

Sarah Adams sarahwbs at gmail.com
Mon May 28 15:13:33 CDT 2007

> 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

Oh dear god. Even your suggestion, rudy, my favourite SQL guru, did
not work; I got the same error message "The table 'Reservations' is

I suppose I could create a copy of the table and make it work that
way. I just hate to give in like that. But if all else fails, that's
what I'll do.

More information about the thelist mailing list