Just wondering if this is the best way to do this update statement:
UPDATE [table1]
SET [field2] =
(SELECT [field2] FROM [table2] WHERE [table2].[field1] = [table1].[field1])
If you would write this statement another way, please do post.
Thanks,
Michal.