Re: Using multiple tables in update

Try following script

UPDATE table1

   SET table1.field1 =
    (select table2.field1 from table2
      WHERE table1.fieldA = table2.fieldA )

make sure the number of rows returned should be unique, otherwise the logic would not be correct.

George Xu
Nortel, IS
at george_xu_at_nt.com Received on Tue Jul 23 1996 - 00:00:00 CEST