That's what I had first but got a syntax error at "inner".
I've got it to work using this:
update agreementitems
set new_iagreementid = agreements.new_iagreementid
from agreements where agreementitems.iagreementid = agreements.iagreementid
but I would love to know if the other way works or not
>Try
>update agreementitems
> set new_iagreementid = agreements.new_iagreementid
> inner join agreements on agreementitems.iagreementid = agreements.iagreementid
>
>
>>
>>I'm using PostgreSQL and trying to run the following update:
>>
>>update agreementitems
>>set agreementitems.new_iagreementid = agreements.new_iagreementid
>>from agreementitems inner join agreements on agreementitems.iagreementid = agreements.iagreementid
>>
>>however, I get this error:
>>
>>ERROR: table name "agreementitems" specified more than once
>>
>>This syntax works in VFP (and I think in SQL Server). Can anyone suggest the syntax that PostgreSQL uses?