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

Question

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

Hemant Srivastava · 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

Hanook · Answer

UPDATE a SET a.NAME = b.NAME a.MOBILE = b.MOBILE FROM Table_A a JOIN Table_b b ON a.EMPID = b.EMPID