[DUG-DB]: UPDATE

[John Christenhusz]

G'day all,

I want to copy a row of data from one table to another. Both tables are
indexed with field name ID.

What I want is to copy the data from Table1 field 'OldField' to Table2 field
'NewField'

The following doesn't work, obviously the last WHERE clause sees only one
column.

        UPDATE TABLE2

        SET NewField =

        (SELECT a.OldField
         FROM TABLE1 a,  TABLE2 b
         WHERE a.ID = b.ID)

         WHERE TABLE1.ID = TABLE2.ID


Any ideas how to do this?

TIA

winmail.dat
Description: application/ms-tnef