how to update table

[JPCogAdmin]

Trying to update one table from the value of another table.
The relationship is one-to-many. Here is my code:

update table1 as t1 set field4 = (select field7 from table2 as t2 where t1.id = t2.id )

Table1 has many and table1 has one. Thanks.

 

[lespaul]

maybe:

UPDATE Table1 T1 INNER JOIN Table2 T2 ON T1.ID = T2.ID SET t1.field4 = T2.Field7

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

 

[JPCogAdmin]

LesPaul,

Thank you. That worked.
;-)