I’d like to understand if the following is possible, because it seems like it isn’t but perhaps I have missed something.
Company XYZ has 3 directors each with their own officer_id.
I want to find all related companies where any of these 3 directors are also directors. I have understood how to do this using the officer_id: that doesn’t present a problem. The problem is searching for related companies where it is the same director BUT with a different officer_id.
For example:
- John Devanport - officerID = 987654321 - DOB = 12/1978
- John Mike Devanport - officerID = 123456789 - DOB = 12/1978
A human understands this is (probably) the same person very easily. Is there a way to search using Name + DOB to return a list of officer_id’s?
Many Thanks,
Keith