DECLARE @A TABLE (ID INT IDENTITY(1,1),NAME VARCHAR(20))
DECLARE @B TABLE (ID INT IDENTITY(1,1),NAME VARCHAR(20))
INSERT INTO @A VALUES('A TEJAS')
INSERT INTO @A VALUES('A JAYESH')
INSERT INTO @A VALUES(null)
INSERT INTO @B VALUES('B TEJAS')
INSERT INTO @B VALUES('B JAYESH')
INSERT INTO @B VALUES('B KRUNAL')
SELECT * FROM @A
SELECT CASE WHEN A.NAME IS NULL THEN B.NAME ELSE A.NAME END AS NAME FROM @A AS A
INNER JOIN @B AS B ON A.ID = B.ID
ID NAME
1 A TEJAS
2 A JAYESH
3 NULL
NAME
A TEJAS
A JAYESH
B KRUNAL
the other way is like this
SELECT ISNULL(A.NAME,B.NAME)
suggested by barneyman