Inserting values into a column when Table1 column A value matches Table 2 Column B Value I have two tables ImportData and PurchaseInfo. I am trying to import [Supplier Contact Name] from ImportData to PurchaseInfo, when *[SupplierName] in ImportData = *[SupplierName] in PurchaseInfo

This is the query I tried:

INSERT INTO PurchaseInfo ([Supplier Contact Name]) 
SELECT [Supplier Contact Name] 
FROM ImportData 
WHERE PurchaseInfo.[Supplier Name] = SupplierInfo.SupplierName  


I get the error 

Msg 4104, Level 16, State 1, Line 2
The multi-part identifier "PurchaseInfo.Supplier Name" could not be bound.


Any help would be greatly appreciated.
Taking a guess that Vinny wishes to update the PurchaseInfo table, and that SupplierInfo is same as ImportData

UPDATE PurchaseInfo 
SET [Supplier Contact Name] = S.[Supplier Contact Name]
FROM ImportData I JOIN PurchaseInfo PI ON PI.[Supplier Name] = I.SupplierName