Chi Pheo wrote:


Try:

update table1 t1
set t1.id = (select t2.id
from table2 t2
where t1.code = t2.code)


--
Larry DiGiovanni
Digico, Inc.
IT Consulting and Staffing Solutions
www.digicoinc.com
Check out www.thedbcommunity.com for Paradox resources.

Hello!
I have 2 tables: table1.db (id, code, name) and table2.db (id, code, name)
with the same structures.
Due to some reasons I must update tables: set table2.id = table1.id where
table2.code = table1.code
I tried to do like this:

update "table1.db"
set "table1.db".id = "table2.db".id
where ("table1.db".code = "table2.db".code)

But It does not work.
Pls help me.
Thanks in advance!

Wow, thank you so much!
It works well.



"Larry DiGiovanni" <nospam (AT) nospam (DOT) com> wrote