Access Update query....using information from one table on another

I am trying to update information in one table with information from another. I would like to do this by matching one record in each and if they match insert the relevant data.

This is my query currently:

UPDATE [Combined List], [Account Name] SET [Combined List].[Account Name] = [Account Name].[Name]
WHERE ((([Combined List].[Premise Code])=[Account Name].[Premise Code]));

When run all I get is a blank column called Account Name but with the correct number or records that should have been edited.

If anyone could help me on this I would be greatful as I am having a mental blank day.

---------
I have had another look at this and have found one problem which leads me into another...

I am not actually selecting anything to update. But the next problem then is how to run a sub query to select on the record I want to update???