Subject Re: [ib-support] Updating Data from multiple Tables
Author Helen Borrie
At 01:08 AM 03-12-01 -0500, you wrote:
>How would I permanently update the data in a file in table a
>with data from table b.
>I have tried this and I get an error:
>update a set testfieldname = b.fieldvalue from a, b
>where a.fieldid = b.fieldid

update a t1
set testfieldname = (select fieldvalue from b t2 where t2.fieldid = t1.fieldid)


All for Open and Open for All
InterBase Developer Initiative ยท