A somehow sophisticated Update Query !

[cement]

Hi,



i have two tables which don't have any relationships and i can not set any for them because of some reasons.

Table1 has am ID field (numbers) and Table2 records have those ID numbers and they are identical.

what i want to do is to update the Table2 records which have the same IDs as my Table1 records and update (i.e modify ! ) their content with the content of the corresponding Table1 record (which has the same ID)

hope i explained well.

does some one know how could it be done ?
Thanks in advance,

[ajetrumpet]

try something like:

UPDATE table2, table1 SET

table2.field = table1.field

WHERE table1.ID = table2.ID

[ajetrumpet]

received a reputation from OP. marking thread as solved.