query possible

HI

I basically have 2 table

Table A = First_Name , Last_Name, Address

Table B = First_Name, Last_Name, Social

What I basically want to do is create a new field in Table A called "Social" and match and insert the socials from table B into Table A , where last name matches


Thanks in advance

 

bump

is this that hard?

 

update tableA A set social = (select social from tableB B where B.last_name=A.last_name limit 1)

 

check out this also

UPDATE TABLEA
SET SOCIAL= B.SOCIAL

FROM
TABLEA A
INNER JOIN TABLEB B ON B.LNAME=A.LNAME

 

Update tablea
set social= b.social

from
tablea a
inner join tableb b on b.lname=a.lname

 

thanks this works great