Hi

I used to work with DBISAM and there is UPDATE with JOIN.

update table1 set field1=table2.field3, field2=table2.field4 from table1
inner join table2 on (table1.field1 = table2.field1)

In ElevateDB AFAIK there is not.

I am using the following statement:

update table1 set (field1,field2) = (select field3,field4 from table2 where table1.field1=table2.field1)
where field1 in (select field1 from table2)

My question:
This is right ? Is there another way ?

Thanks in advance
Eduardo

Jose


Looks right to me. I don't think there is another way (apart from Delphi).

Roy Lambert

Roy

<<
Looks right to me. I don't think there is another way (apart from Delphi).
>>

Thanks for the feed back and sorry for delay the answer

Eduardo