I have 2 tables named bank and roll. What I want to do is to compare the names in the roll table with the info section in the bank table. But there is more than one of the same name. If half of the names or surnames are valid, the code counts. Do these names match the names in the info section? If so, is the amount deposited in the ban correct?

enter image description here