Monday, 9 September 2013

Joining by field and changing it at the same time

Joining by field and changing it at the same time

I have two tables - one with people who have emails and other with email
list. Some of emails need to be cleared.
I'm thinking of the query like this:
UPDATE Person
SET Person.Email=''
FROM Person INNER Join EmailList
ON Person.Email=EmailList.Email
And EmailList.Reset='Y'
My question is - will it work? Will it make a joined new table first and
then change the values or may joining and value changing somehow interfere
and make unpredictable result?

No comments:

Post a Comment