• 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]

    SQL-4-Life