Update emails query

[Caleb]

Hello, I'm building a query that will update the emails in a list of
customers. I have two tables, 'Master_List' and 'NEWCompleteList', both lists
contain customer records. The Master_List's records are more complete,
however the 'NEWCompleteList' is way more recent and therefore contains many
new emails. I want to update the emails in the 'Master_List' with the emails
in the 'NEWCompleteList'. All I've been able to acomplish so far is a query
that contains both tables and Joins the email field to include all records
from 'NEWCompleteList and only records from 'Master_List' where the email
field is equal. This pulls up a list of all the emails I need from
NewCompleteList and I can tell if I dont need one because there will be an
email under the Master_List. Now I just dont know how to get those emails to
replace the old emails. Any help would be appreciated, thanks

Here is the SQL:

SELECT [Master_List (FULL NAME)].[E-mail] AS [Master Email], [Master_List
(FULL NAME)].[Full Name] AS [Master Name], NEWCompleteList.Email AS [New
Email], NEWCompleteList.FirstName AS [New List FName],
NEWCompleteList.LastName AS [New List LName]
FROM NEWCompleteList LEFT JOIN [Master_List (FULL NAME)] ON
NEWCompleteList.Email = [Master_List (FULL NAME)].[E-mail];