I want to replace the value of a field in a table with the value that I have in another table... I have one unique common field..

is some easy way to do it with SQL statement...

regards
JP

Let's see if I've understood what you're looking for:


UPDATE table1
SET field in table 1 to update =
(
SELECT field in table 2
FROM table2
WHERE field of unique id in table 2 = id to match table 2
)
WHERE field of unique id in table 1 = id to match table 1;