Hi I have worked out what I need from a previous post, I think it is working how I want.

UPDATE    Subset

SET              Subset.Leadengineer = Contact2.ULEADENGIN

FROM         heat2.Subset Subset INNER JOIN

                      Goldmine.dbo.Contact2...