Andre du Plessis <[EMAIL PROTECTED]> wrote:
The Id piece works great thanks! If I want to update 2 fields on table
A, the following syntax doesn't work as expected, as it updates all to
records to 'DONE'.
update A set Flag = 'DONE',
Id = coalesce(
(select Id from B
where A.Field1 = B.Field_Temp and B.Price > 0),
Id);
Of course. What do you want it to do? What exactly are you trying to
achieve?
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------