I have 2 tables (Prsnl, dataImport)
In Prsnl I have 2 fields (fullName,EDIPI)
In dataImport I have 2 fields(Name,EDIPI)
The EDIPI field in Prsnl is blank, and I want to fill it with the values from dataImport.EDIPI
The query I tried was
SET Prsnl.EDIPI =...