Find Unmatched Name Where Duplicate SSN ?

[AshleyRickards]

Here's my issue. I need to find names that don't match but with same SSN. Example:

SSN NAME
123456789 Ashley Rickards
123456789 Bob Smith

TIA Ashley L Rickards
SQL DBA

 

[Discord]

how about

SELECT A.SSN, A.LastName, A.FirstName, B.LastName, B.FirstName
FROM

insert table name here

 AS A INNER JOIN

insert table name here

 AS B ON A.SSN = B.SSN
WHERE (A.LastName <> B.LastName) OR (A.FirstName <> B.FirstName)

 

[AshleyRickards]

Thanks! I'll give it a try. Ashley L Rickards
SQL DBA