compare two tables if tableb coloum is null repalce table a

Question

I HAVE TEO TABLES LIKE..

TABLE_A

SNO NAME MOBILE EMPID
1 RAJU 9014494876 A12345
2 VAMSHI 9765432123 B12367
3 KARTHIK 986623456 C34567

TABLE_B
SNO NAME MOBILE EMPID
1 SRINU 970123454 D123489
2 RAJENDER 'NULL' B12367
3 KARTHIK 934642389 C34567

COMPARE TWO TABLE A & B EMPID AND IF TABLE B MOBILE FIELD 'NULL' UPADATE TABLE A MOBILE TO TABLE B

i want o/p like table_b
SNO NAME MOBILE EMPID
1 SRINU 970123454 D123489
2 RAJENDER 9765432123 B12367
3 KARTHIK 934642389 C34567

plz write quarie ...................

Jignesh Trivedi · Answer

hi Try.... create table #TABLE_A ( SNO int NAME varchar(20) MOBILE varchar(20) EMPID varchar(20) ) create table #TABLE_B ( SNO int NAME varchar(20) MOBILE varchar(20) EMPID varchar(20) ) insert into #TABLE_A values(1'RAJU''9014494876''A12345') (2'VAMSHI''9765432123''B12367') (3'KARTHIK''986623456''C34567') insert into #TABLE_B values(1'SRINU''970123454'' D123489') (2'RAJENDER'null'B12367') (3'KARTHIK'' 934642389''C34567') update #TABLE_B set MOBILE = a.MOBILE from #TABLE_B inner join #TABLE_A a on a.EMPID = #TABLE_B.EMPID where #TABLE_B.MOBILE is null and #TABLE_B.EMPID = #TABLE_B.EMPID select * from #TABLE_B hope this will help you.

JAYRAM · Answer

WRITE QUARIE UPDATE TABLE B.................

Brijendra Gautam · Answer

Do you want just a query for this output then below is the query SELECT B.SNOB.NAMEB.EMPIDISNULL(B.MOBILEA.MOBILE) MOBILE FROM TABLE_B B INNER JOIN TABLE_A A ON A.EMPID=B.EMPID And if you want it to be updated in TABLE_B also then query will be different.