I always seem to remember the access syntax for this rather than the sql server version–
update
hachette_digitalideas_import
set
harrietId = u.Id
from
hachette_digitalideas_import h
left outer join user_group u
ON (h.email = u.email or h.[full name] = u.name) AND u.btype = 'u'
As opposed to the following in access;
update
hachette_digitalideas_import
left outer join user_group u
ON (h.email = u.email or h.[full name] = u.name) AND u.btype = 'u'
set
harrietId = u.Id
Related posts:
#1 by Michael A Reeds MD PhD on May 21, 2011 - 03:07
Just the thing my failing memory was trying to recapture.