Could anyone help me about the syntax of an update query ? And/or how to build it with the graphic interface ? I would like to update Field1 from Table1 by the value of Field2 from Table2, when Table1.Id1 = Table2.Id2 (both primary keys of their tables). I was accustomed (with Oracle) to write this so, as far as I remember :
UPDATE Table 1 SET Field1 = (SELECT Field2 FROMTable2 WHERE Table1.Id1 = table2.Id2); How can I translate that into modern Sql :-) Thanks GC [Non-text portions of this message have been removed]
