Example We are looking to join rhs_table onto lhs_table for the playerIds. Every person in lhs_table has a corresponding row in rhs_table, however the joins are not so simple: For Nia Johnson Jr., Jr. is missing in rhs_table For Kay Sieper, her full name Kayla is used in rhs_table We want to ignore (ie not left join) RHS players on