I would greatly appreciate any help! I have this table:
Employee:
Id,
Name,
Country.
I need to join between any row only if the country are the same, and only if there is at most one char that not matches in the name.
For example: emp1:(1, "ABCDE", "u.s.a") match to emp2: (2, "ABFDE, "u.s.a")
The mismatch can be only in the same index.
How can I do it?
Thank you!
