[sqlite] Re: Re: inner join

[Igor Tandetnik]

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]
-----------------------------------------------------------------------------