COMPARE TWO TABLES AND REPLACE TABLE B COLOUM DATA TO .....

i have two tables A & B

table_A
SNO NAME FATHER NAME MOBILE ADDRESS EMPID
1 SHASHI RAJESH 9346543215 HYDERABAD 19765
2 RAMU PRAVEEN 7894532155 HYD 1954
3 SRINU VAMSHI 8765432345 HYD 19763

table_B
SNO NAME FATHER NAME MOBILE ADDRESS EMPID
1 SHASHI VARD RAJESH VAR 9014494765 HYDERABAD 19765
2 PRAVEEN SHYAM 8985500166 HYD 19543
3 SRINU SRINU 8985500166 HYD 19763

both tables a & b have same EMPID COLOUM but different data ............
using table_B COULOUM EMPID compare table_A COLOUM EMPID REPLACE table_B NAME ,MOBILE COLOUM DATA TO table_A NAME ,MOBILE

I want output like this
table_A

SNO NAME FATHER NAME MOBILE ADDRESS EMPID
1 SHASHI VARD RAJESH 9014494765 HYDERABAD 19765
2 PRAVEEN PRAVEEN 8985500166 HYD 19543
3 SRINU VAMSHI 8985500166 HYD 19763

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Hemant Srivastava13y ago
Accepted answer
Try this:

UPDATE table_A
SET NAME = B.NAME
, MOBILE = B.MOBILE
FROM table_B AS B, table_A AS A
WHERE A.EMPID = B.EMPID
Hanook13y ago
UPDATE a
SET a.NAME = b.NAME,
a.MOBILE = b.MOBILE
FROM Table_A a
JOIN Table_b b ON a.EMPID = b.EMPID