Looking at the following query:

Select

Table2.PId,

Table2.SSN,

Table2.Name

From

Table1

Inner Join Table2

On Table1.PId <> Table2.PId

And Table1.SSN <> Table2.SSN

another alternative could be:

Select

Table2.PId,

Table2.SSN,

Table2.Name

From

Table1

Inner Join Table2

On Table1.PId <> Table2.PId

Or Table1.SSN <> Table2.SSN

Boolean logic:

NOT (A = B and C = D) == A <> B or C <> D