Andre du Plessis <[EMAIL PROTECTED]> wrote:
I would like to be able to accomplish the following but don't see any
support for inner joins on update queries.
update A
set Id = B.Id
from A inner join B
on A.Field1 = B.Field_Temp
where B.Price > 0
update A set Id = coalesce(
(select Id from B
where A.Field1 = B.Field_Temp and B.Price > 0),
Id);
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
