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

[victor gutierrez]

UPDATE Reservations

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



victor gutierrez escribió:
> Sarah Adams escribió:
>   
>>> 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
>> ambiguous".
>>
>> 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.
>>   
>>     
>
>
>   


-- 
*Victor Gutierrez*

:e: victor.gutierrez at intelygenz.com
:t: 615 097 033
:msg: vgutierrez_intelygenz at yahoo.es
	*Intelygenz*
c/ Santa Engracia 151, 1ª planta, oficina 1
:cp: 28003 Madrid
:t: 91 535 96 12
http://www.intelygenz.com
Intelygenz - Tecnología transparente <http://www.intelygenz.com> 
Intelygenz - Tecnología transparente <http://www.intelygenz.com>