HI there,
Have you tried using a join instead:
update [2009]
set [2009].organization_name = e.organization_name
FROM test_2009 [2009]
INNER JOIN org_2008 [2008]
ON [2008].organization_name = [2009].organization_name
WHERE [2009].organization_name=''
Thaks
Chris
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]