Grab value from another table via foreign key

Question

I have two tables in my SQL Server database:

Person

ID Lastname  Age
1  Jones     46
2  Smith     37

Employee

ID(FK) Firstname Surname
1      Bob       [empty string]
2      Janet     [empty string]

I want to combine Employee as follows. (I will then be removing the Lastname from person, but let's not worry about that for now.)

Employee 
ID (FK)   Firstname  Surname
1         Bob        Jones
2         Janet      Smith

How can I do that?

SQL newbie, picking up a project, sorry if it's an obvious question. — William Jockusch, Jan 26 '16 at 18:45
This is the question I really wanted to ask: http://stackoverflow.com/questions/224732/sql-update-from-one-table-to-another-based-on-a-id-match — William Jockusch, Jan 26 '16 at 19:21

score 2 · Accepted Answer · answered Jan 26 '16 at 18:44

2

I Think you should try this query, by this way you will have your desired result based on both tables.

Select E.ID, E.FirstName P.Lastname As Surname From Person P
Inner join Employee E ON p.ID = E.ID

answered Jan 26 '16 at 18:44

Chiragkumar Thakar

3,616
5
37
49

score 2 · Answer 2 · answered Jan 26 '16 at 18:45

2

Select E.ID, E.Firstname, P.Lastname as Surname from Employee E 
inner join Person P on P.ID=E.ID

answered Jan 26 '16 at 18:45

Haytem BrB

1,528
3
16
23

Grab value from another table via foreign key

2 Answers2