compare two tables if tableb coloum is null repalce table a

JAYRAM

12y1.6k

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 ...................

3 Replies

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

Jignesh Trivedi12y ago
Accepted 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.
0
JAYRAM12y ago
WRITE QUARIE
UPDATE TABLE B.................
0
Brijendra Gautam12y ago
Do you want just a query for this output then below is the query

SELECT B.SNO,B.NAME,B.EMPID,ISNULL(B.MOBILE,A.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.
0