IF you are trying to return SSN from table2 only if SSN doesn't exist in table1 and return "No SSN Found" only if it doesn't exist in table1 and table2...

CREATE TABLE tabA (
    ID VARCHAR(5)
   ,[Name] VARCHAR(50)
   ,Phone VARCHAR(50)
   ,Code VARCHAR(2)
)

INSERT INTO TABA
VALUES 
('15674','AUSN ','+14412984775','HT')
,('15674','MAN','+13857747488','JK')
,('98765','AUSN ','+74666378838','HT')
,( '67866'...

• This reply was modified 4 years, 8 months ago by  RC.
• This reply was modified 4 years, 8 months ago by  RC.