merge query question

[Alex18]

[quote=Alex gRin]I have a table that kind of looks like this


eID FIRSTNAME LASTNAME
1 Tom Smith
2 Sam Smith
3 Jack Smith

And another table that looks like this

eID SALARY FIRSTNAME LASTNAME
1 1000
2 2000
3 3000

What is the right query to take the firstname lastname from table one and insert it to table 2 so that the name matches with id and would look like this

eID SALARY FIRSTNAME LASTNAME
1 1000 Tom Smith
2 2000 Sam Smith


I tried one query before but it does not matches the info

Thanks

[Alex18]

I have a table that kind of looks like this


eID FIRSTNAME LASTNAME
1 Tom Smith
2 Sam Smith
3 Jack Smith

And another table that looks like this

eID SALARY FIRSTNAME LASTNAME
1 1000
2 2000
3 3000

What is the right query to take the firstname lastname from table one and insert it to table 2 so that the name matches with id and would look like this

eID SALARY FIRSTNAME LASTNAME
1 1000 Tom Smith
2 2000 Sam Smith


I tried one query before but it does not matches the info

Thanks
[/QUOTE]