When you are doing equality matching on the same attribute, this condition is usually sufficient:

Record1.Forename = Record2.Forename

But when you want to do a match on different attributes, for example:

Record1.Forename = Record2.Nickname

then this is no longer sufficient, as it is possible to miss one direction.

The match condition needs to be:

Record1.Forename = Record2.Nickname
OR
Record2.Forename = Record1.Nickname

Step-by-step guide

Related articles