I have 2 tables :

Table1 :
Cust ID Name Address
001 John Smith 1 Rodeo St

Table 2 :
Name Phone Fax
John Smith 1111 2222


I would like to join 2 tables so I can get customer phone and fax, so I need to join by name since table 2 does not have customer ID. Certainly, there is no problem when the name is consistent. However, there might be a customer where the name in table 1 is Ben Smith and the other one is Ben Smith Jnr and also there could be more than one customer with the same name.

Does anyone have experience with this and maybe can reduce the error from joining those 2 tables ?

Thanks