Unable to compose correct UPDATE ms sql query?

Question

Microsoft SQL Server Management Studio

Hi all! I can’t deal with this problem:
There is an Import table (full):

I need to copy columns from it (FirstName, LastName, Email) to the BolTest table (empty):

I try to make a copy with this query:

update BolTest
set
BolTest.FirstName=Import.FirstName,
BolTest.LastName=Import.LastName,
BolTest.Email=Import.Email
from BolTest inner join Import
on BolTest.StaffId=Import.StaffId

I execute the request, it writes in the message line "Lines processed: 0", it seems to me that the problem is in the condition line "on BolTest.StaffId=Import.StaffId", and I really don’t know what the reason is, I’m very familiar with sql. Please point out my mistake, what am I doing wrong?
PS Thank you very much!

Answer 1

Update is a change to existing data. If you need to create new data use Insert