سلام.

اینو امتحان کن:


UPDATE test2
SET Gheymat = test1.Gheymat
FROM test1
WHERE test1.id = test2.id


https://stackoverflow.com/questions/...-on-two-tables