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)

cheers,
Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________